If I understand correctly your job schedule table needs to be 1 record per "employee assigned" per job per week rather than having multiple "employee assigned" values in the same record. Then your list of available employees would be all where there is no record that contains that employee.

Hope this helps. BTW, I used to line in Gainesville back in the 80's. Worked in the oilfields.

To be honest I find this website almost unusable (i,.e just can't figure it out) so if you respond I will try to return the favor but I would not guarantee it.

John