Create Relationship Dialog Box
Enables you to confirm the related columns and to set properties for a new relationship.
This dialog box appears when you draw a relationship line between two tables in your database diagram.
Relationship name
Displays the system-assigned name of the relationship. To rename the relationship, type a new name in the text box.
Primary key table
Shows the name of the primary key table in the relationship, followed by the columns that make up the primary key. You can select different columns to match the columns shown under Foreign key table.
Foreign key table
Shows the name of the foreign key table in the relationship, followed by the columns that make up the foreign key. You can select different columns to match the columns shown under Primary key table.
Check existing data on creation
Applies the relationship to existing data in the foreign key table when the relationship is created. An error message will notify you of any data that violates the constraint if this box is selected.
Enforce relationship for INSERT and UPDATE
Selecting this options enforces the constraint whenever data is added to or updated in the foreign key table using these statements.
Enforce relationship for replication
Selecting this option enforces referential integrity for the relationship whenever the foreign key table is replicated to a different database.
Cascade update related fields
Instructs the database to propagate new key values to corresponding foreign key fields whenever a primary key value is updated.
Cascade delete related fields
Instructs the database to delete corresponding rows from the foreign key table whenever rows from the primary key table are deleted.
OK
Creates the relationship with the properties you selected.
Cancel
Erases the relationship line from your database diagram. The relationship is not created.
For more information about creating relationships between tables, see Creating a Relationship Between Tables.
See Also
Database Designer Dialog Boxes | Relationships Property Page