I have in my database 3 tables
Supervisor, which contain personal information about the supervisor like
ID,
Name,
Dob
I have another table like Department
DepartmentID,
SuperviserID,
and so forth
and a 3rd table that contains status information
SupervisorID, DepartmentID, Date, Status
Whenever a supervisor is blocked the info is entered in the status table vice versa
now I want to able to block(adding info) all department related to this particular supervisor when he is blocked.
Does anyone have an idea?
Best regards