Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
FK numbering in Visio
45 views
Skip to first unread message
omer...@gmail.com
Jun 10, 2009, 4:25:41 AM6/10/09
to
Hi,
I have reverse engineered a database using Microsoft Visio 2007. There
are some tables which essentially have only one Foreign key relation
but the diagram is showing FK1,FK2 against these. Why is it so and why
two FKs when there should be only one? Thanks.
Best Regards,
Omer Javed
Barb Way
Jun 11, 2009, 8:26:50 PM6/11/09
to
This will occur when you have a relationship to two different columns which
happen to have the same name, whether or not they are the same field.
Visio automatically aggregates items with the same name into a line in the
Table display, and notes the FK instances in the first column.
happen to have the same name, whether or not they are the same field.
Visio automatically aggregates items with the same name into a line in the
Table display, and notes the FK instances in the first column.
Check your originating db for duplicate names in different tables.
Barb Way
Product Support - Visio
Microsoft Corporation
[This posting is provided "As Is" with no warranties, and confers no
rights.]
0 new messages