filter a dropdown based on a report in another table
Two Tables - Jobs and Installs I have a report in Jobs that I want filtered based on the value of "Location" in the Installs table. How can I accomplish this?
Forum Discussion
Not trying to do a 'conditional' dropdown. Got that to work. Thanks!
In my installs table, I have a location field that the user selects. When the user selects a location, i have a second dropdown box, which is populated by a report from the Jobs table, which needs to know the selected location to filter the report correctly.
I hope this makes sense. The title may be the confusing part.
In my installs table, I have a location field that the user selects. When the user selects a location, i have a second dropdown box, which is populated by a report from the Jobs table, which needs to know the selected location to filter the report correctly.
I hope this makes sense. The title may be the confusing part.
This is the essence of a 'conditional' dropdown. When one dropdown options are conditional based on some other dropdown.
If you want the Jobs dropdown to only show options that match that 'location' you will need a 'locations' table.
using a multiple choice field for location will not give you a pre-filtered list.
If you want the Jobs dropdown to only show options that match that 'location' you will need a 'locations' table.
using a multiple choice field for location will not give you a pre-filtered list.