Re: Designer 2000, use of foreign keys

In article <6130dk$suv_at_drn.zippo.com>, Dan Peacock <?@?.?> writes
>In article <6WCUXDA30PN0MwmY_at_camk.demon.co.uk>, Andy says...
 [snip]
>>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?
>>
>Right. The way it works is the entity on the "from" end of the realation ship
>gets the added column. For example:
Hm...

Doesn't work for me :(

I'm just using a simple one-to-one relationship and no matter which entity I select as to or from, the entity whose name appears first alphabetically seems to get the extra columns.

On 1-to-many, the extra column always seems to be added to the many side of the relationship?

Andy

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