Originally Posted by
Homegrownandy
Do you need to store additional info if he is a supervisor? Or do you just want to know he is one?
If you dont need any addtional info there may be no needfor the supervisors table at all. (feel free to correct me if im wrong).
you could have a checkbox for each record where yes = supervisor and no = not.
OR.. lets say you want to know supervisors/managers/labourers/whatever. I wouldnt do a checkbox for each, I would create a table for defining their "role".
you would then be able to select the role for each member of staff, the table would only store the ID.
If you require more information than just what their job title is, then look at creating a junction table inbetween "staff" and "job title".
Thats how i would approach it anyway.