Relational Error Message

Hi Danny,

Thank you for your question.

The issue seems to be that your Primary and Foreign Keys do not contain the same Data Type and/or Field size.

E.g. If the Primary key is an Autonumber Data Type, then the Foreign key has to be a Number Data Type and Long Integer.

E.g. If the Primary key was a Number Data Type and the field size was Integer, then the Foreign Key must be Number Data Type and Integer Field Size.

E.g. If the Primary Key was Text Data Type and 200 Field size, then the Foreign Key must be Text Data Type and Field Size 200.

So you need to go into the tables containing the Foreign Keys and ensure the Data Type and Field sizes are the same as the Primary Keys. Once you have edited those keys then try the relationships again.

I hope this answers your question.

Regards

Simon