Good afternoon, I have a question.... Is there any way that if I select the "dropdown_code" with its corresponding code, the value will automatically change in the "dropdown_description"? As you can see, there are two dependent dropdown lists. I have tried to change the second dropdown "dropdown_description" for a "text_field" but when I place the query with a property it brings it as a -dataset- and not as a value to display, like a string.... Any idea?. I leave some captures and the queries I used.
The intention is that when selecting the code from the first drop-down list the description of that code is automatically displayed. The following image shows how the query works but the idea is that it does not have to be selected...
PS: Forgive me for my English, I'm helping myself with Google Translate...