I want to create an attribute-form that displays some fields in value-related dropdowns. The goal is to limit the options in the second dropdown dependent upon the selection in the first dropdown. In my case, I have the following two fields that should be related:
- List "Schwachstelle" with attributes ID (PK) and Name
- List "Schwachstelle_spez" with attributes ID (PK), Name and ID_Schwachstelle
The key-attributes between the two lists are the ID of "Schwachstelle" and ID_Schwachstelle of "Schwachstelle_spez".
The filter I wrote for the value-dependent dropdown ("Schwachstelle_spez") is the following:
"ID" = current_value( 'Schwachstelle_ID' )
However, this does still show all possible values in the "related" dropdown.
(I took https://www.youtube.com/watch?v=8shIZrwlQt4 as an example)
If the user were to choose "Nutzungskonflikte", "Umwege" would not apperar in the following dropdown.