title: MS Access 2013 - One dropdown dependent on another in datasheet view
body: <p>I have a view in MS Access 2013 that is in the datasheet layout. The view is based on a single SQL Server 2012 table and is editable.</p>
  
  <p>I have two columns in the datasheet view that are linked to dropdowns where the user can select values. Based on the value of the first column, I want the second column to be filtered on a subset of values that meet the criteria in the first column.</p>
  
  <p>The lookup values come for each column come from two tables (from SQL Server 2012, but stored as views in MS Access):</p>
  
  <p>Table 1: (Number is the "ID" and description is the "label")</p>
  
  <ol>
  <li>Open</li>
  <li>Action</li>
  <li>Closed</li>
  </ol>
  
  <p>Table 2:</p>
  
  <ol>
  <li>Met Criteria (pertains to Table1ID #1)</li>
  <li>User Added (pertains to Table1ID #1)</li>
  <li>Sent for review (pertains to Table1ID #2)</li>
  <li>Response Received (pertains to Table1ID #2)</li>
  <li>Finalized (pertains to Table1ID #2)</li>
  <li>Did not meet criteria (pertains to Table1ID #3)</li>
  <li>Process completed (pertains to Table1ID #3)</li>
  </ol>
  
  <p>The intended functionality is that if the user selects "Open" in the first column (dropdown is based on values in Table 1), that the second column will only display IDs #1 and #2 from Table 2 as valid selections (i.e. dropdown for the second column is filtered where Table1ID = 1).</p>
  
  <p>If a record is already filled out (e.g. column 1 has ID 1 and column 2 has ID 2) and a user edits the record, for example selecting ID 2 in column 1, then column 2 will remove the invalid combination (e.g. column 2's ID of 2 is no longer valid as it is not part of the subset for Table 1's ID selected, which is now 2, changed from 1).</p>
  
  <p>My question is above, but for clarity, I have the SQL views and datasheet views the way I want and have the dropdowns working independently of each other (albeit column 2 shows all values in table 2), I just need assistance with relating/linking the two dropdowns together.</p>
  
  <p>Thank you in advance for your assistance.</p>