Relationships - Microsoft Access Expert 4


	Back to Access Expert 4 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Relationships

Mark Parsons

5 years ago

Hi Richard, when i attempt to establish a relationship between my CustomerT and my FamilyMemberT it says it must be the same data type. My CustomerTID is the Autonumber Primary key, the FamilyMemberT is set as a foreign key (Number). But when i try to set the Referential Integrity rule i get a error message.

	Scott Axton @Reply 5 years ago
In the table that you are relating you need to add the id field from the other table. If you have CustomerT - CustomerTID - Autonumber The other table FamilyMemberTID - Autonumber (Primary Key) CustomerTID - Number Field Size - Long Integer (Foreign Key) Double check the number type in FamilyMemberT. It must be Long Integer.

	Mark Parsons OP @Reply 5 years ago
Hi Scott, Im pretty sure I did check that. But Ill check again, thanks for your help_

	Mark Parsons OP @Reply 5 years ago
Hi Scott, you were right. I had to delete my relationships first, as the number was set as a double, I changed it and re established the relationships. And no error message, thanks so much for you help.

	Scott Axton @Reply 5 years ago
Glad that worked!

	Richard Rost @Reply 5 years ago
Mark - in the future, when you get an error message, make sure you tell us what the error message is - word for word. Makes it easier for us to help you.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 4.

Next Unseen

New Feature: Comment Live View