Another way to ensure your database is solid is to allow Access to check referential integrity. Establishing referential integrity establishes a relationship between tables to ensure data integrity. This relationship is a Parent/Child relationship where the Parent is the Primary table. The Primary table in a relationship is the table where the common field is the primary key field. The Child table is the table where the common field is not a primary key field. Letting Access control referential integrity ensures that database relationships aren’t impaired when you alter data.

To enable this option, switch to the Tables section of the database window. Then, click the Tools menu and click Relationships. In the Relationships window, double-click the line for the relationship that you want to edit.

 

 

Then, ensure Enforce Referential Integrity is checked.

 

 

Next, click OK. That’s it!