What you describe is a bit difficult to picture, but it sounds like you want what I call a "Hierarchical Conditional Value List" and you want the option of getting a list of values after first selecting one of two different values that differently filter the list by a different type of "category". But I could easily be misreading your post.
You might look at the Hierarchical Conditional Value List examples found in:
"Adventures In FileMaking #1 - Conditional Value Lists" which can be downloaded from: https://www.dropbox.com/s/oj15fqp1uakg0d7/Adventure%201%20CVLs.fmp12?dl=0
One example has a CVL that always lists values. If none of the category and sub category values are selected, you get all values in the list. If you select a general category you get a list of all items in the general category. But if you then select a sub category, the same field and same value list shrinks further to just the values in the sub category.
Thank you for you're answer.
The hierarchical CVL is close to what I want but...
In my problem it is not the case that an option of the lowest level only belongs to one higher level option.
My lowest level is basically a set of characteristics that can belong to different products. (in a city example a city can only belong to one state), therefore it is not possible to base the product name on a selected characteristic (as it is possible to base the state on the name of a city).
Therefore I don't think that I can solve my problem with a hierarchical CVL.
I don't see how that will keep the hierarchical method from working. I suggest taking a closer look at the examples provided. One version uses SQL queries to pull up the desired list of values and the fact that you are querying for values with a characteristic that is not exclusive to a given category does not keep the query from finding all records with that characteristic.