There are two tables:

1. Contains all of the employees in my department. Each record has a field that contains the user id. The record with my name has SDE in this field.

2. This is a table that holds a work schedule. Each record has week ending field, a job number field, and a scheduled resources field, example

04/25/04 MES4410 SDE,CMA,EPY
04/25/04 MES9999 CMN,SGE,MJS

This tells what employees are working on which jobs on each week.

To fill this second table out my manager pulls up a form with this table in it as a grid. The week ending and job number fields are filled out from another source. He has to assign employees to each record. A list needs to show up on the form also with all the available resources(easy part) and as he assigns employees to each record the avaliable list should decrease by the assigned employees(hard part since I have to compare a multi list string(SDE,EPY,CMA) to several single record fields). If I get assigned to a job in the grid my name(user id ) should not be listed to be used again until a week is access that I am not scheduled in.