title: Insert new record into a table from a form, using data from multiple tables
body: <p>I am fairly new to both Access and Databases and I'm struggling with how to add a new record into a table using a form, which gets its options from multiple other tables.</p>
  
  <p>I have 4 tables which contain: a list of periods (tblPeriod), a list of pupils (tblNames), a list of subjects (tblAreaOfLearning) and a list of levels (tblLevels).</p>
  
  <p>I want to create a form which will allow a user to select the period, then the pupil, then the subject, and then the level at which that pupil is attaining at that subject, and then add the ID's for all of these into a 5th table called tblMaster</p>
  
  <p>I have no idea how to do this though? I have created a query linking everything to the master table by the ID's, but i have no idea how to create the form and the command to insert this into the new table?</p>
  
  <p><img src="https://i.stack.imgur.com/Mst2y.png" alt="enter image description here"></p>
  
  <p>All help appreciated</p>