Re: No one-to-one (optional) in Designer 2K SMD???

One to One is enforce in the physical database as a one to many you have to create a unique index to enforce the one-to-one.

Mark
Designer Consulting
800-483-8771

Keith Kwiatek wrote in message <7aul2a$38t$1_at_news.nist.gov>...
>Hello,
>
>I have an erd diagram with a one-to-one optional relationship....it does
not
>translate in the Design editor server model diagram....it becomes a
>one-to-many ? I can't even manually insert a one-to-one in the server
model
>diagram? Why?
>
>
>Also, in a one-to-one, how do you tell the database transformer to convert
>the one-to-one relationship A) correctly and B) with the foreign key in a
>certian table?
>
>Thanks!
>please post or email me at kkwiatek_at_nist.gov
>
>Keith
>
>
Received on Wed Feb 24 1999 - 20:10:02 CET