Can an Access table has 2 foreign keys
Results 1 to 2 of 2

Thread: Can an Access table has 2 foreign keys

  1. #1
    Join Date
    Nov 2013
    Posts
    1

    Question 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,

  2. #2
    Join Date
    Oct 2006
    Location
    Sydney NSW Australia
    Posts
    252
    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
  •