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

From: Jon Maz <>
Date: Fri, 7 Mar 2003 16:52:34 +0100
Message-ID: <b4af3j$qcc$>

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

Original text of this message