AnsweredAssumed Answered

Filter a Value list

Question asked by OtisReeves on May 28, 2014
Latest reply on May 29, 2014 by OtisReeves


Filter a Value list


     I have a database that tracks jobs.. Under each job I select which employee worked on that job using a Value list of my Personnel table. The personnel table has 200 names.. but only 50  still work for me. the Table has a Current employee field with values "0" for former employee and "1" for current employee. I want to only be able to select from employee in that table that has a value of "1" What is the best way to do this?

     The Jobs table is linked with my Employee table Via "Employee ID#"