Relationships Property Page

      

This property page contains a set of properties for the relationships between the tables in your database diagram.

Options

Selected relationship

Shows the name of the selected relationship in your diagram. If more than one relationship is selected in your diagram, only the name of the first relationship in your selection is visible. Expand the list to choose a different relationship to show properties for.

Relationship name

Shows the name of the selected relationship. You can rename the relationship by entering a new name in this box. For more information, see Renaming a 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. For information about changing the primary key, see Modifying a 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. For information about changing the foreign key, see Modifying a Foreign Key.

Check existing data on creation

Applies the constraint to data that already exists in the database when the relationship is added to the foreign key table.

Enable relationship for INSERT and UPDATE

Applies the constraint to data that is inserted into 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.

Enable relationship for replication

Applies the constraint when the foreign key table is copied to a different database.