.Access this form by selecting the Tables node (within a database) on the
navigation pane, then
select the required table in the
object list and click
the manage relationships icon .
Name
Shows the name of the selected relationship.
Primary key table
Shows the name of the primary key table in the relationship, followed by the
columns that make up the primary key.
Foreign key table
Shows the name of the foreign key table in the relationship, followed by the
columns that make up the foreign key.
Check existing data
Applies the constraint to data that already exists in the database when the
relationship is added to the foreign key table.
Enforce relationship for replication
Applies the constraint when the foreign key table is copied to a different
database.
Enforce relationship for INSERTs and UPDATEs
Applies the constraint to data that is inserted into, deleted, or updated in
the foreign key table. Also prevents a row in the primary key table from being
deleted when a matching row exists in the foreign key table.
Cascade UPDATE related fields
Instructs the DBMS to automatically update foreign-key values of this
relationship whenever the primary-key value is updated.
Cascade DELETE related fields
Instructs the DBMS to automatically delete rows of the foreign-key table
whenever the referred-to row of the primary-key table is deleted.