FK numbering in Visio


O

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
 
Ad

Advertisements

B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top