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
If you want to have a 'conditional' dropdown on a table you need to have at least 3 tables involved. It sounds like you might only have 2 (Jobs and Installs). If you want conditional based on location, you will need to make a 3rd table of 'Locations' and have that be a parent to both the Jobs and Installs.