Relationshiips MUST be defined on fields of the same data type and number.
Change the foreign Key field to a Long Integer.
George Hepworth
GPC Data
MS Access MVP 2007-2011
425 876 0535
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
the_extinguisher_pro
Sent: Monday, May 30, 2011 3:51 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] A question on Relationships
Lets see if I get this right...
When I make a relationship between tables, I should bound the primary field
on the one side with the foreign key on the many side, right? When I try to
do this an set Referential Integrity, I get a message saying that
"Relationship must be on the same number of fields with the same data
types". Now how would this be posible if the primary key on the one side of
the relationship is the auto number and the foreign key on the many side is
a text field? Am I doing something wrong?
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar