title: Microsoft Access 2013 - Multiple Foreign Keys in the same Record
body: <p>I’ve encountered a problem with pulling multiple foreign keys into one record in a Microsoft Access table.</p>
  
  <p>I’ve got two tables with these fields:</p>
  
  <p>Table 1: 
  Owners
  Fields:
  Owner ID (Primary Key)
  First Name
  Last Name</p>
  
  <p>Table 2:
  Ships
  Fields:
  Ship ID (Primary Key)
  Ship Name</p>
  
  <p>I need to create a relationship between Table 1 and Table 2 which shows who owns the ship. I’ve tried adding a number field to Table 2 called Owner ID (Foreign Key) and this works absolutely fine. </p>
  
  <p>Working Example:</p>
  
  <pre><code>Table 1 – Owners                  Table 2 – Ships 
  Owner ID (Primary Key)__          Ship ID (Primary Key)
  First Name              \         Ship Name
  Last Name                \________Owner ID (Foreign Key)
  </code></pre>
  
  <p>Unfortunately my ships in Table 2 can have multiple owners (up to 5) at the same time. My problem arises when I try to create a series of linking fields in Table 2.</p>
  
  <p>Not Working:</p>
  
  <pre><code>Table 1 – Owners                     Table 2 – Ships 
  Owner ID (Primary Key)__             Ship ID (Primary Key)
  First Name              \            Ship Name
  Last Name                \           Owner1 ID (Foreign Key)
                            \______/   Owner2 ID (Foreign Key)
                                   \   Owner3 ID (Foreign Key)
  </code></pre>
  
  <p>Can anyone recommend any workarounds so I can show multiple owners taken from the Owners table in the Ships table?</p>
  
  <p>Thanks for your help!</p>