FK numbering in Visio

[omer.jav]

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]

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.

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.]

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