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.
Displays the system-assigned name of the relationship. To rename the relationship, type a new name in the text box.
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.
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.
Applies the constraint 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.
Applies the constraint when data is added to or updated in the foreign key table using these statements.
Copies the constraint whenever the foreign key table is copied to a different database.
Creates the relationship in your database diagram and sets the properties you selected.
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.