This tab in the Referential Integrity (RI) builder specifies rules to apply when a new record is inserted or an existing record is updated in the child table.

Restrict

Prevents you from adding records in the child table for which there are no matching records in the parent table. If you select Restrict Insert for a relationship, an attempt to add records in the child table generates an error if there is no matching parent record.

Ignore

Makes it possible for you to insert records into the child table regardless of whether there is a matching record in the parent table.

Referential Integrity Grid

Parent TableВ В В displays the name of the table in the database relation containing the primary or candidate index. Child TableВ В В displays the name of the child table in the database relation. UpdateВ В В displays the update rules for referential integrity for the relation. Possible values are Cascade, Restrict, or Ignore. You can change the settings by selecting the field, which will present a drop-down list of the choices. DeleteВ В В displays the delete rules for the referential integrity for the relation. Possible values are Cascade, Restrict, or Ignore. You can change the settings by selecting the field, which will present a drop-down list of the choices. InsertВ В В displays the insert rules for the referential integrity for the relation. Possible values are Cascade, Restrict, or Ignore. You can change the settings by selecting the field, which will present a drop-down list of the choices. Parent TagВ В В grid column displays tag name of the index in the Primary or Candidate in the Parent table. Child TagВ В В grid column displays the tag name of the index in the child table.

See Also

Send comments about this topic to Microsoft. В© Microsoft Corporation. All rights reserved.