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 ParsonsOP
@Reply 5 years ago
Hi Scott, Im pretty sure I did check that. But Ill check again, thanks for your help_
Mark ParsonsOP
@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.
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.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 4.
