Forum Discussion

JonathanAlbert's avatar
JonathanAlbert
Qrew Member
2 years ago

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 t...
Relationships
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
@Jonathan Albert  You need to do what Jeremy suggested. 
Make a report of just those Teams members in the Role = DE.  Then edit the form properties to have the form use that filtered report for the drop down field as opposed to the default "Record Picke fields"​

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
JonathanAlbert's avatar
JonathanAlbert
Qrew Member
2 years ago
Thank 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
------------------------------