Automatic dependent dropdown lists with querys

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...

Hi Jose,

1 Like

thank you very much it worked for me.


I changed the dropdown to a textfield and it works directly

thanks again

1 Like

I think you should change it to a label. If you want to keep it a Text Field then set enabled : false so the user can't override what the dropdown is setting.

1 Like

Yes, I just did that, it still works for me to keep it as a text field, thank you very much.