I am learning MS Access 2013 and try to create relationships with 3 tables. When I list them without the Enforce Referential Integrity option the relation is generated, however, when I put the same option I get the error:
"no unique index found for the referenced field of the primary table"