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