[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?

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 7
• New Files 2

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

---

Get great advice about dogs and cats. Visit the Dog & Cat Answers Center.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___