Search code examples
ms-accessms-officeforeign-key-relationshipdatabase-replicationautonumber

Access Enforce Referential Integrity Error: Relationship must be on the same number of fields with the same data types


In Access 2013, I am trying to link an AutoNumber with the field size set to "Replication ID" to another table with "Enforce Referencial Integrity" enabled.

However, I am unable to find a field type that does not provide a "Relationship must be on the same number of fields with the same data types" error.


Solution

  • I have found an answer.

    The Number data type has several options for the size of the field, one of such options is "Replication ID", with the field set as such, I was able to successfully create the relationship.