Forum Discussion

BrianAdamson's avatar
BrianAdamson
Qrew Trainee
8 years ago

Create a table using a subset of another table to use in conditional drop down

I have a "Companies" table and a "Contacts" Table. In my "Contacts" table I have a drop down to select the company associated with that contact. I also have a field in my "Contacts" table that is a ch...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
No problem,
Do not create a new table.  Just make a report called Managers Only used on Drop down list where you have a filter so that it is just managers.  Then do to the form where you have the drop down being selected and on the FORM properties choose that report.  

Your existing Conditional Drop down will continue to filter for just the Contacts for the company and the Report filter will further filter that down to just Managers.