I have a “Contacts” table that lists people. From that table, I have created a “Team Members” table that lists team members for multiple projects (people from the “Contacts” table via ID number) by name and their job titles. I have another layout where I want to automatically take the person holding the Project Manager title from this “Team Members” table and automatically insert them into a new field called “Project PM”. I am not sure how to do this. Any help is appreciated.