title: How to link a field from a different table in a form in MS Access
body: <p>Bear with me; I have very little MS Access experience, by plenty of SQL experience.</p>
  
  <p>This is the basic data structure:</p>
  
  <p>I have an Employee table, a Training table, and a joining Employee_Training table (many-to-many relationship). There is a list of employees, and a list of possible training that those employees can do. Any employee may have attended several training sessions, where each entry has a recorded attendance date.</p>
  
  <p>I am trying to make a form that performs in the following way:</p>
  
  <ul>
  <li>You select an employee from a combobox at the top of the page</li>
  <li>The form contains a list of all possible training sessions, each with a label and a textbox. If the employee has attended a training session, the corresponding textbox has the attendance date in it, otherwise the text box is blank.</li>
  <li>I want to be able to enter a date in a blank textbox, or change the date in a non-blank textbox.</li>
  <li>I can't use a DataSheet view because there are about 150 training types, and this needs to be converted into a printable form, so the information is compressed in columns on the form, like below:</li>
  </ul>
  
  <p>Rough Layout: </p>
  
  <pre><code>Select Employee: [ John Smith | v ]
  Training type 1: [          ]  Training type 25: [          ] 
  Training type 2: [          ]  Training type 26: [ 05/06/15 ] 
  Training type 3: [          ]  Training type 27: [          ] 
  ...                            ...
  </code></pre>
  
  <p>The form was originally created by hand, but now is created by a VBA script, though I don't think that will be too relevant here.</p>
  
  <p>How do I structure the form's record source and the control source of the text boxes to allow me to see what I want to see, and edit what I need to edit?</p>