Specify+Referential+integrity+options

How to prevent users from making changes to their document's field values used in the relationship in Microsoft Access 2007.
In Microsoft access 2007 on the relationship Tools design tab on the Ribbon, in the tools group, click the edit relationships button, Edit Relationships dialog box opens and displays the tables and the common field used in the selected relationship.



In the edit relationships dialoge box, click the enforce referential integrity, check box to select it. selecting the enforce referencial integrity option will prevent users from making changes to the field values in the common field used in the relationship.

Then click the cascade deleate related records check box to select it. when this option is selected, deleting a record from the primary table also automatically deletes all the records in the related table that contains matching values in the common field.

Click Ok. The edit relationships dialog box closes, and the relationship is update.

In access on the relationship Tools design tab on the Ribbon, in the tools group, click the edit relationships button. Edit Relationships dialog box opens and displays the tables and the common field used in the selected relationship. In the edit relationships dialoge box, click the enforce referential integrity, check box to select it. selecting the enforce referencial integrity option will prevent users from making changes to the field values in the common field used in the relationship. Then click the cascade delete related records check box to select it. when this option is selected, deleting a record from the primary table also automatically deletes all the records in the related table that contains matching values in the common field. Click Ok. The edit relationships dialog box closes, and the relationship is update. Then make sure to save your work on either your flash drive or on your Desktop.