title: MS Access link to SQL Server - validate input against 2nd table?
body: <p>I'm trying to think of the easiest way for non-tech users to dump info into a database, without coding my own web application.</p>
  
  <p>Essentially, they are recording subjective phone grading scores for employees.</p>
  
  <p>I linked an Access form to our MS SQL Server database. The only validation I want it -- I want one field, 'employee' - to be validated against a list of employees from say table.employee on SQL Server.</p>
  
  <p>Once the form is submitted it will be written to table.scorecard -- or what have you.</p>
  
  <p>Is this possible in Access? Their standard validation rules don't seem to cover this. Also, is there simply a better way to accomplish this task in general? Thanks</p>