Hi everyone ![]()
I'm trying to filter with controls and I would like to have only possible values when I choose a filter and I have to filter with another one.
Above an example:
| filter 1 | filter 2 |
| apple | fruits |
|lemon |vegetables |
| orange | animals |
| melon |
| tomato |
| potato |
| bird |
| dog |
For example if we decide to filter with filter2 ANIMALS we will have as result all the options of filter 1.
| filter 1 | filter 2 |
| apple | animals |
|lemon |
| orange |
| melon |
| tomato |
| potato |
| bird |
| dog |
BUT we want to have only in filter 1 the animals: BIRD and DOG.
| filter 1 | filter 2 |
| dog | animals |
| bird |
This is what we are wishing for.
We have tried with parent control choosing filter2 as parent and filter1 as child and this works but the problem is that the filter1 is locked if filter 2 isn't selected and we don't like it.
thanks ![]()