Re: Designer 2000, use of foreign keys

For 1:1, the product has never been consistent. At one time, it created foreign key columns for both tables!

Andy Hardy <Andy_Hardy_at_camk.demon.co.uk> wrote:

>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

-JJ

 Jeffrey Jacobs & Associates
 Oracle Designer/2000 Consulting & Training  951-2 Old Country Road, Suite 119, Belmont, CA 94002  Voice: 415-571-7092, FAX: 800-665-1379 CompuServe: 76702,456  Internet: 76702.456_at_compuserve.com     Received on Tue Oct 07 1997 - 00:00:00 CEST