Check existing data when creating a relationship (ADP)

Note  The information in this topic applies only to a Microsoft Access project (.adp).

Select the option to check existing data when you create a relationship if the foreign key constraint should apply to existing data as well as to new data.

1. In the Database window, click Database Diagrams under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar.
2. In your database diagram, select the table that the foreign key constraint is attached to.
3. Right-click the table and select Relationships.
4. Select the relationship from the Selected relationship list.
5. Select the Check existing data on creation check box.

The foreign key constraint is applied when you save the table or diagram. If any constraint violations are encountered during the save process, the table cannot be saved.