Schleid Alex

Schleid Alex

  • 1.8k
  • 361
  • 26.1k

Help with entering information base on another table

Oct 15 2020 12:58 AM

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

Answers (2)