Referential Integrity Builder

  • Article

The Referential Integrity (RI) builder helps you ensure referential integrity by setting up triggers to control how records are inserted, updated, or deleted in related tables.

The RI Builder is displayed when you:

  • Double-click a relationship line between two tables in the Database designer and choose the Referential Integrity button in the Edit Relationship dialog box.
  • Choose Edit Referential Integrity from the Database Designer shortcut menu.
  • Choose Edit Referential Integrity from the Database menu.

Builder Tabs

  • Rules for Updating
    Specifies rules to apply when the key value in the parent table is modified.
  • Rules for Deleting
    Specifies rules to apply when a record in the parent table is deleted.
  • Rules for Inserting
    Specifies rules to apply when a new record is inserted or an existing record is updated in the child table.

For more information, see Developing Databases, Trigger Usage, and Working with Tables.

See Also

Builders | Database Designer | Edit Relationship Dialog Box | Rules for Deleting Tab | Rules for Inserting Tab | Rules for Updating Tab | Building Referential Integrity