Relationships Property Page

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

Table name

Shows the name of the table in Table Designer or the selected table in your database diagram. If more than one table is selected in your database diagram, only the name of the first table is visible.

Selected relationship

Shows the name of the selected relationship in your database diagram. If more than one relationship is selected in your database diagram, only the name of the first relationship in your selection is visible. Expand the list to view or modify the properties of a different relationship.

Each entry in the drop-down list is preceded by an icon. A key icon indicates that the table participates in the relationship as the referred-to table. An infinity icon indicates that the table participates as the referring table. (The referring table has the relationship’s foreign-key constraint.)

New

Choose this button to create a new relationship for the selected database table. For more information, see Create a Relationship Between Tables.

Delete

Choose this button to remove the selected relationship from the database. For more information, see Delete a Relationship.

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 Rename 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 Rename 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 Modify 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.

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

(Microsoft SQL Server 2000 only.) Instructs the database to automatically update foreign-key values of this relationship whenever the primary-key value is updated.

• Cascade Delete Related Fields

(SQL Server 2000 only.) Instructs the database to automatically delete rows of the foreign-key table whenever the referred-to row of the primary-key table is deleted.

Validation Text

(SQL Server 2000 only.) Shows the text that is displayed to the users whenever a row that violates the foreign-key constraint is entered.