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.