title: Microsoft Access: Using a form to set the value of primary keys and then moving those values into two tables when record is created
body: <p>Microsoft Access:
  I have a form, it contains a combo box for 'Primary Key 1', 'Primary Key 2', 'Data A' and 'Data B'. Each combo box has a list of values to choose from. When I create a new record, how can I set up the form so that: the value for 'Primary Key 1', 'Primary Key 2' and 'Data A' are moved into 'Table A'; and the value for 'Primary Key 1', 'Primary Key 2' and 'Data B' are moved into 'Table B'.</p>
  
  <p>The issue here is getting the values set for the two primary keys into two tables.</p>
  
  <p>Form:
  <br/>Primary Key 1
  <br/>Primary Key 2
  <br/>Data A
  <br/>Data B</p>
  
  <p>Table A:
  <br/> Key 1
  <br/>Primary Key 2
  <br/>Data A</p>
  
  <p>Table B:
  <br/>Primary Key 1
  <br/>Primary Key 2
  <br/>Data 2</p>