title: Access 2013 Web App - multi value lookup
body: <p>I'm creating a personal Access 2013 Web App on Sharepoint.
  I want to make a form for a table that will lookup an ID number based on multiple criteria.
  The table describes projects with some fields, we'll call them location, category, and units.</p>
  
  <pre><code>relating_table:
  id    location    category       units
  1     france      maintenance    hours
  </code></pre>
  
  <p>then my project table would have</p>
  
  <pre><code>id    fk_id    teamid     whatever
  1     1        x          y
  2     1        z          a
  </code></pre>
  
  <p>I want to set up my form so the user can choose "france" "maintenance" and "hours" and the form will know to input 1 for the "fk_id"</p>
  
  <p>Most things I find on Google are for client-based Access databases. I tried to make the web app do a query through macros or something, but I can't find anywhere to type in SQL statements, which is very frustrating.</p>
  
  <p>edit* my terminology may be incorrect regarding 'multivalue lookup'. I definitely do NOT want to store multiple values in a single field. I want to return a single value based on multiple criteria.</p>