How are primary key integrity and foreign key integrity enforced?

There are four update actions we can set when we create foreign keys in related tables:

• No action.

• Set null.

• Cascade.

• Set default.

To set up referential integrity using DBATool:

1. From the Object menu, choose the Table command. The Table dialog box appears.

2. Click the "+" beside Foreign label near the bottom of the dialog box. The Create Foreign Key dialog box appears.

3. From the Update Action pull-down menu choose the desired action.

4. Click OK to close the Create Foreign Key dialog box. Click Close to close the Table dialog box.