Referential Integrity Builder

See Also

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 "Creating Stored Procedures" in Chapter 6, Creating Databases and "Using Triggers" in Chapter 7, and Working with Tables, in the Programmer's Guide.