FK Propogation

[Mark DJ]

When defining PK for specfic tables that already have a parent-child
relationship with another table Visio wants to add that column to a related
table even when that FK is NOT defined as a column in the related table. What
feature or option should be checked to prevent FK columns to propogated to
other table that do not contain these columns? The

 

[Barb Way]

Yes - the default is to propagate the FK to the 'child' on creation of the
relationship, and propagate the removal when the relationship is deleted
from the model. However, you can change either or both of these actions :

Database Menu
Options
Modeling
select Logical Misc tab

-- To prevent the addition of the child field, uncheck the Propagate
on Add option under FK propagation
-- To prevent the removal of the child field, uncheck the Propagate
on Delete option under FK propagation

Click OK to save

NOTE: If you do not allow Visio to create the child field automatically,
you will have to manually define the columns which participate in the
relationship.
In the Relationship Definition window, which opens automatically, you
manually select a column in the Parent section and associate it with the
desired column in the Child section, and then click on Associate to
complete the relationship.


Barb Way
Product Support - Visio
Microsoft Corporation
[This posting is provided "As Is" with no warranties, and confers no
rights.]
--------------------
Thread-Topic: FK Propogation

When defining PK for specfic tables that already have a parent-child
relationship with another table Visio wants to add that column to a related
table even when that FK is NOT defined as a column in the related table.
What
feature or option should be checked to prevent FK columns to propogated to
other table that do not contain these columns? The