ContributionsMost RecentMost LikesSolutionsRe: Populating a Multiple Choice field from limited data set from a different tableThank you @Jeremy Anson and @Mark Shnier! Sorry, I misunderstood the solution when I read it. But, you're right, that is exactly what I needed to do and its working great. Thanks again! ------------------------------ Jonathan Albert ------------------------------ Re: Populating a Multiple Choice field from limited data set from a different tableNo, I'm not trying to do any reporting. This is all for data entry on the Application Table. On the Application Table, I have many fields, 3 of which are: 1) DE - Text - Multiple Choice 2) BA - Text - Multiple Choice 3) PM - Text - Multiple Choice Rather than have the users manually type people names into those fields, I have those fields connected to the Project Team table using a Relationship. The Project Team table has these fields: 1) Name 2) Email 3) Role However, the only way I see to make the connection is to bring in all names on the Project Team table rather than just the Role I want for each field. For example, in the Application table, for the multiple choice field for DE, I want the drop down to only show those names from the Project Team table that have a Role=DE. Thanks ------------------------------ Jonathan Albert ------------------------------ Populating a Multiple Choice field from limited data set from a different tableHi I have a table for our Project Team and that consist of 3 Roles: PM, DE, BA. There are about 100 entries on this table, with fields for Name, Email, Role In my main Application table, I'd like to have the user assign a PM to the Project Manager field, a DE to the Data Engineer field and a BA to the Business Analyst field. I can use a relationship to bring the entire Project Team table eam listing into each multiple choice dropdown field, but is there a way to only display the Role=PM in the Project Manager dropdown field, only Role=DE to the Data Engineer dropdown field, etc? Thanks ------------------------------ Jonathan Albert ------------------------------