title: Access 2013 using a lookup field with multiple values
body: <p>I'm using a database which contains a Staff table and a Groups table, what I'm trying to do is so that each staff member can be a member of many groups and each group can contain multiple staff, many-to-many relationship. I also have a join table connecting the two (below is my table structure). Both the Staff and the Groups table have a one-to-many relationship with the Group Staff table.</p>
  
  <p>Staff Table</p>
  
  <pre><code>Staff ID
  First Name
  Last Name
  </code></pre>
  
  <p>Group Table</p>
  
  <pre><code>Group ID
  Group Name
  </code></pre>
  
  <p>Group Staff Table</p>
  
  <pre><code>Group Staff ID - PK
  Group ID - FK
  Staff ID - FK
  </code></pre>
  
  <p>What I'm trying to do is in the Groups Table, I have a field called "Members" which should contain all the staff (looked up from the staff table) who are members of the group. I'm using a lookup field to display all the Staff members. The problem is that I can't select multiple staff for each group, which I need to.</p>
  
  <p>If I try and change the lookup field to "Allow multiple values" then it tells me I can't because of the relationship between the Staff and the Group table, but of course I need the relationship to be able to lookup the Staff members.</p>
  
  <p>So how can I make it so I can can have a lookup field in the Group table that allows me to select multiple Staff from the Staff Table? Any help is appreciated.</p>