I want to create 2 dropdowns that are interdependent.
Example:
first dropdown: |Monika|Laura|Steven (variable i)
second dropdown: |January|February|March (variable z)
So my problem is:
Only one dropdown should be used at a time..
that means.. when I select Monika, Laura or Steven I want the second dropdown to show me the value '', but still have the list with "January, February, March" when extending the second dropdown.
same with the second dropdown, when I select January for example, the first dropdown should show me '', but still have the list with "Monika, Laura, Steven"
depending on which dropdown I use, the other dropdown should be something like "inactive"
What I did:
first dropdown form. editor
if(z<>'','','|Monika|Laura|Steven')
second dropdown form. editor
if(i<>'','','|January|February|March')
but this doesnt work well, the problem is the "then"-term I guess, but I dont know how to fix that..
