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
Hi Jason,
Are Jobs and Installs related tables? If so how are Jobs and Installs related?
If Jobs is the parent of Installs then you would need to add a lookup field from Jobs down to Installs that is the Location of the Job. Then you could build your report to filters off this new lookup field. I hope this suggestion is helpful but if this isn't your set up please let me know how your setup is different and ideally we can help you find a solution.
Are Jobs and Installs related tables? If so how are Jobs and Installs related?
If Jobs is the parent of Installs then you would need to add a lookup field from Jobs down to Installs that is the Location of the Job. Then you could build your report to filters off this new lookup field. I hope this suggestion is helpful but if this isn't your set up please let me know how your setup is different and ideally we can help you find a solution.