title: MS Access - auto populate field based on another selection
body: <p>I'm working in Access.  One of the fields in the Main table is the Employee lookup field form the employees table.  Also in the employees table is that rate per hour for each employee.  So how do I set the rate field in the Main table automatically to update when the employee is selected?</p>
  
  <pre><code>MainTable
  EmployeeID            Rate
  123                   
  
  EmployeesTable
  EmployeeID             Rate 
  123                    330.00
  </code></pre>