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,
Matthew brings up a good point I read the contents of the question where it asked about filtering a report, but I didn't see the filter a dropdown as well in the question title. For that it would take a few more layers. If it was just about filtering the report itself having the lookup field should be enough to edit the report settings and add a filter to the report based upon it but if you are looking to instead create a conditional dropdown that does add extra layers to the set up.
Matthew brings up a good point I read the contents of the question where it asked about filtering a report, but I didn't see the filter a dropdown as well in the question title. For that it would take a few more layers. If it was just about filtering the report itself having the lookup field should be enough to edit the report settings and add a filter to the report based upon it but if you are looking to instead create a conditional dropdown that does add extra layers to the set up.