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
Hmm, I thought I posted an response hours ago, but I don't see that it saved.

I think that you are just overthinking this.

1. Create a report of all mangers.
2. Edit the Form properties for that drop down field and tell the form to use that report.

The field itself will filter just contacts for the Company based on that Conditional Drop down you set up,  and then the managers report will filter that down to just managers.