2

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.

kolcinx
  • 2,183
  • 1
  • 15
  • 38
Arthur Uzulin
  • 83
  • 1
  • 7

2 Answers2

1

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.

Arthur Uzulin
  • 83
  • 1
  • 7
1

To create a relationship with "Enforce referential Integrity" between two fields, the fields Data Type and Field Size must be the same.
You can have for exapmple two tables you want to join.

Table Projects (primary key ID): 

Field Name        Data Type      Field Size
ID                AutoNumber     Long Integer

Table Tasks (foreign key ProjectID): 

Field Name        Data Type      Field Size
ProjectID         Number         Integer

Access will let you join these fields, but will not let you check "Enforce referential integrity".

kolcinx
  • 2,183
  • 1
  • 15
  • 38