I have 4 tables that talk to each other.
Project Table Will update the Supervisor that manages the Account.
- This filters down and updates our Project Session Table with that supervisor name
- This filters down to Employee Assignment Table with that supervisors name.
The Employee Table houses all the Employees Names which is used when adding an assignment.
I need to find a way to copy any supervisor changes into the Employee Table.
Where I am stuck is that the Project Table is where the Supervisor would be updated.
But I need to pull the supervisor name from any active assignment the Employee has and add it to a Employee table field that is a List Users field.
If the supervisor is removed, then it should remove that supervisors name from the List Users field on the employee record.
Any help is appreciated :)
------------------------------
Amber Anderson
------------------------------
