AnsweredAssumed Answered

Populating a field from a table entry.

Question asked by dbakewell on Jul 16, 2018
Latest reply on Jul 17, 2018 by philmodjunk


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.