Create Relationship Dialog Box

Lets you 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. If you select this box, an error message will notify you if any data that violates the constraint exists.

Enforce relationship for replication

Selecting this option enforces referential integrity for the relationship whenever the foreign key table is replicated to a different database.

Enforce relationship for INSERTs and UPDATEs

Selecting this options enforces the constraint whenever data is added to or updated in the foreign key table using these statements.

• Cascade update related fields (Microsoft SQL Server 2000 only)

Instructs the database to propagate new key values to corresponding foreign key fields whenever a primary key value is updated.

• Cascade delete related fields (SQL Server 2000 only)

Instructs the database to delete corresponding rows from the foreign key table whenever rows from the primary key table are deleted.

Validation Text

Shows the text that is displayed to the users whenever a row that violates the foreign-key constraint is entered.

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 Create a Relationship Between Tables.