Problem Using Custom AutoNumbers in MS Access 2013

[RachidTom]

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

 

[USAFRet]

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?

 

[RachidTom]

Than you , but what is the solution if i'd create auto alphanumeric column and rely it to other table ?

 

[USAFRet]

Than you , but what is the solution if i'd create auto alphanumeric column and rely it to other table ?

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.