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.
 
Top