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. - Ok. Maybe I'm confusing this.
JOBS table
Ready to Build report
INSTALLS table
Dropdown box #1 - "Location" (user selects a location)
Dropdown box #2 - Select "job to schedule" (this is being populated by the READY TO BUILD report in the Jobs table). I need "Location" from the installs table to filter the report in the job table.
I gotten the dropdown box to populate without the filter.
If I am making this harder than I should, please explain how you would do it.
Thank you for all of the help with this.
