Problem Using Custom AutoNumbers in MS Access 2013

RachidTom

Commendable
Jun 17, 2016
2
0
1,510
This can't be work when i'd add a new record in the related table , it tell me that i must have the same type of data in the two columns
 


Yes, if the 2 columns are linked somehow, they need to be the same data type.

Now...what are you actually trying to do?
 


In both tables, they need to be the same data type.

What is the basis of what you're doing? Work, school, general farting around?
Aside from "same data type", we can't really answer this.