Is it possible to do this in a report: have 2 dropdown filters (values from related tables), where the second dropdown values are filtered based on selection in the first dropdown? Essentially, conditional dropdown features in report filters, similar to that of forms.
Hello Sharon. I do have that set-up and it works well in a form. However, in the report the second dropdown shows all the values even before the 1st dropdown has been selected. Whereas in the form, the second dropdown has no values until the first dropdown is selected. Any suggestions on how to fix this? Thanks ins advance.
It's a Table style report, not Grid Edit. I have 3 tables: Building, Location and Workstations. Building to Location is one to many; Location to Workstations is one to many; Building to Workstations is one to many relationship. See attached picture for the Related Location field set-up.