title: Access 2016: How to save Form entry data in a specific table based on the entry data?
body: <p>I spent about ten minutes trying to find the best question that describes my problem, so it may not be the best one. </p>
  
  <p>I am doing a database from scratch for practice. This is a brief explanation of what I have:</p>
  
  <p>I have tables  A,  B,  C, and D.------         A,B,C,D are part numbers.</p>
  
  <p>Then I have a Form where I have to enter the part number, date, temperature, name, result1, and result2. </p>
  
  <p>Here is what I am trying to do:
  - If I enter part number A, I want to save all the information in the table A.
  - If I enter part number B, I want to save all the information in the Table B.
  - Same with the rest of the part numbers.</p>
  
  <p>What would be the easiest way to do this?</p>
  
  <p>Thanks you all for your comments. </p>