ER Relationship automatically ADD additional field ??

[tristant]

Hi all,

I am using Visio for enterprise architect to create ER modelling.
The problem is :
When I try to connect two tables with Relationship connector, it
automatically ADD additional fields as reference fields.
Obviously this is not necessary since the reference field for both table is
already there, BUT with different name.
So that I have to delete the added fields manually and then re-associate the
relationship using the actual fields on both column.

How can I tell visio not to add additional fields when I make relationship ?

Thank you for your help,
Krist

 

[Chang Oh]

You can turn off the automatic propagation of columns from Database Modeling
Preferences dialog. Do Database > Options > Modeling and select Logical
Misc. tab to turn off. Note that you will have to do this for each diagram
you open/create because this is a model-level option.

~~~~~~~~~~~
The information provided is AS-IS with no express warranty.

Chang Oh
Dev Lead
Enterprise Frameworks & Tools