I would like to have a rapport, query, form, whatever is needed to make a dropdown filter.
So there are two Tables. Table 1 consists of option 1, 2, 3,… Table 2 consists of option A, B, C,…
When using this filter, I would like to have 2 dropdown menus. Dropdown menu 1 is for choosing the right Table and dropdown menu 2 is for choosing the right option. Another problem with this is that table 1 has other kind of options than table 2. (See picture 1 and 2)
After these two are selected there will appear a list which consists only of the wanted information. (See picture 3)
You will be a real hero to help me with this.