Relational problem

[Charlie]

I am having a problem setting up the relations in this access file.
can someone show me my error please.
The file is here http://homepage.ntlworld.com/charlie_chuck/Jade Office Suppliers.mdb

 

[Dugantrain]

OK, you've got two problems here. I'm assuming that Equipment is your "one" table and Test History is your "many" table. If this is true, then change the data type of equipment ID in Test History to Long Integer. Also, you have a number (4) in the Test History table that is not in the Equipment table. When you join these tables by the Equipment ID, numbers must first exist in the Equipment table before they will be allowed in the Test History table. So, change Equipment ID's Data Type to Long Integer, delete the record with #4 in it, write the # 4 equipment information in the equipment table, hook the tables up in your relationship window, and then put #4 back in the test history table. It should then work like a champ

 

[Charlie]

Many thanks, I had already changed the data types to long integer as you recommend.
I stil cannot link the tables, so i am going to try your other suggestion regarding the #4, as have not tried that yet.

Thanks

Charlie