Re: Database design qn for one-to-many relationship
Date: Fri, 7 Mar 2003 16:52:34 +0100
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.
JON Received on Fri Mar 07 2003 - 16:52:34 CET