Re: Designer 2000, use of foreign keys

[Quoted] In article <3433b984.26319019_at_69.0.9.9>, Tim Hall <tim.hall_at_spambuster.com> writes
>On Thu, 2 Oct 1997 14:19:10 +0100, Andy Hardy
><Andy_Hardy_at_camk.demon.co.uk> wrote:
>
 [snip]
>>At table level, after running the database wizard, D2K uses the ERD to
>>determine that a foreign key is required and, therefore, a new column
>>must be added to the created table to facilitate this. You end up with a
>>new column called something like 'FE_FIRST_KEY'.
>>
>
>The column should be a copy of whatever forms the unique identifier of
>the second entity. You should define the UIDs of entities before you
>start using the database wizard.

[Quoted] [Quoted] I'm still having a little trouble with this - I don't know how to [Quoted] 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

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