All Tables, Forms, etc. must be closed before you can create a relationship.
To fix, close all tables, etc. then build the relationship.

You cannot enter the same data into a field that is a primary key.
To fix, change the data in the primary key field to a unique value.

 

There is a relationship between two tables with “Referential Integrity” checked. The data you are trying to enter into the related table does not exist in the primary table’s related field.
To fix, enter the record in the primary table before entering the data in the related table.

Access Errors