Lookup from Child Table
Good Day!
I have 4 tables that talk to each other.
Project Table Will update the Supervisor that manages the Account.
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
------------------------------
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
------------------------------
