foreign key

J

Joan

How can I define forien key? I can't find anywhere. I
have tbl PO and Receipt. I'd like to define PONumber as
foriegn key in Receipt tbl. (I have ReceiptNo as Primary
key in tblReceipt)

Thanks in advance.
 
D

Douglas J. Steele

You create a relationship between the two tables (Tools | Relationships...)

There's no way to indicate something's a foreign key on its own without
having it as part of a relationship.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top