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?
I have created the relationship both ways. I got the location field to appear in the report from the Jobs table, but no results. Any idea what could be wrong?