Re: Designer 2000, use of foreign keys

In article <343512d4.28407487_at_69.0.9.9>, Tim Hall <tim.hall_at_spambuster.com> writes
>On Fri, 3 Oct 1997 15:12:07 +0100, Andy Hardy
><Andy_Hardy_at_camk.demon.co.uk> wrote:
>
>>
>>I'm still having a little trouble with this - I don't know how to
>>determine which of the entities will get the foreign key added to it
>>during the conversion to the database schema. I *think* that the entity
>>which appears first in the alphabet is given the extra columns during
>>the conversion. Surely this can't be right?
>>
>>Andy
>>--
>
>For a one-to-many relationship, the foreign key always goes at the
>"many" end. It's only one-to-one relationships (which aren't very
>common anyway) where the key could theoretically go at either end.
>Off the top of my head, I can't remember the rules for which end it
>goes but I believe it makes use of any volumetric information.
>
Ah, thanks for that - I thought that I was doing something wrong, again!

Andy

-- 
Andy Hardy
Senior IT Systems Engineer
Cegelec AEG
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Opinions are mine and do not necessarily reflect those of Cegelec AEG