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,
So you are looking to filter the report on the parent table by a value in the child table? You want to take the Location from the Installs table and pull it up in the Jobs table and filter the report that way?
So you are looking to filter the report on the parent table by a value in the child table? You want to take the Location from the Installs table and pull it up in the Jobs table and filter the report that way?