Relationships Property Page (ADP)

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.

Delete

Choose this button to remove the selected relationship from the database.

Relationship name

Shows the name of the selected relationship. You can rename the relationship by entering a new name in this 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.

Foreign key table

Shows the name of the foreign key table in the relationship, followed by the columns that make up the 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.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×