JonathanAlbert
2 years agoQrew Member
Populating a Multiple Choice field from limited data set from a different table
Hi
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
------------------------------
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
------------------------------