Re: Des 2K and foreign keys...

John is right about the FK columns.
The other reason could be that under the Options/Settings tab in DDW, the 'Create' column check box must be checked. (it is checked by default)

John Strange wrote in message <6sjcga$6oj$1_at_relay1.dsccc.com>...
>.---. part .---.
>| A |>-----------| B |
>`---' item `---'
>
>If you used the Database Design Wizard, the table with the 'crows' foot (A)
 will contain
>the Primary key column from the other end of the relationship (B).
>The name of the new column in table A, would be PART.
>
>If you did not define a primary key in table B, or did not generate
>table B first, the column will not show up..
>
>
>Tom Schmitt (tom.schmitt_at_us.landisstaefa.com) wrote:
>: How do I transform the relationships defined in my ER diagram into
 foreign
>: key columns. The foreign keys show up after a database transform but
 only
>: as foreign keys...not columns in the appropriate tables.
 

>: Thanks,
>: Tom Schmitt
>: tom.schmitt_at_us.landisstaefa.com
>: --
>: These comments do not necessarily reflect the views of
>: Landis & Staefa, Inc.
>
>--
>While DSC may claim ownership of all my ideas (on or off the job),
>DSC does not claim any responsibility for them. Warranty expired when you
>opened this article and I will not be responsible for its contents or use.
Received on Wed Sep 02 1998 - 00:00:00 CDT