Hi, I am looking for ways to make the choice list of the child select_one choice be relevant to more than one options selected in the parent select_one choice.
For example, I have the choice list of Site to be filtered by Location.
However, I would like to have the choices in Site to be filtered by more than one Location choice, example below:
So that 'Tomato' would be shown on the list when A is selected, and also show when C is selected. I've tried separating the parent choices with a comma as above but it doesn't work, and I've also tried separating with OR (e.g. A OR C) which did not work either. With both comma and OR, the choices list for Site was not displayed at all or the dropdown arrow was not offered (for autocomplete appearance).
Is this type of choice filter possible at all, and if so, how should I separate the parent choices? I've done google searches and community searches but haven't been able to find any mentions of anything similar.
Thank you!