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
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.
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.