-
Can an Access table has 2 foreign keys
I would want to create a table that reference 2 different tables. Does Access allow to do that? For example: a service_agreement table contains contract_number that refers to contract_table, it also has vendor_id that refers to Vendor_table. Is it alright to do that?
Can someone help to answer this question?
Thank you,
-
Yes you can providing they are the same data type.
Allan
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|