I have a base with two tables: Employees and Projects.
Employees has a primary field of Employee ID and Project IDs.
Projects has a primary field of Project ID, Project Manager(s), and Status.
In the Employees table I want the field "Project IDs" to be automatically populated with the corresponding Project ID from the Projects table when the Employee ID matches any names in the Project Manager(s) and when Status is not "Completed".
Sounds like it should be simple. But I can't seem to figure it out. Thanks for any assistance!