I want to use a main form for a project, that shows records from table1, table2 and table3, with filter options for the records of table 1 and 2; also the tables are linked with relationship, table1 with table2 and table2 with table3.
I’ve setup the filter list box for table 1, so now the form navigator is something like filter>table1>table2>table3 (each being a subform of the previous one).
Now I can’t get the list box filter for the records of table 2 to work. At first I tried using a second filter table, in the same manner as with table1, but that doesn’t seem as a good idea anymore.
For the second attempt, I tried to use an extra column in the main filter (instead of an extra filter table) and also change the content type of table2. But I still can’t get the second filter list box to show only records relevant to the table1 selected record.