Re: Database design qn for one-to-many relationship

Hi Damjan,

Thanks for your advice. Your suggested third solution with an Entities table was something I had never thought of - if I were designing the system from scratch, I might do it that way, but since I am now adding this Notes functionality to existing tables, it would be too disruptive to change the way the PK's work in tblPeople, tblCompanies etc.

So I'll do as you recommend, and go for solution #2.

Thanks again,

JON Received on Fri Mar 07 2003 - 16:52:34 CET