I can’t find any documentation on this but is there a way to code a query in the Lookup Setting to use the text value of the listbox entry? I need to use the text value in the query.
Not quite sure because I had trouble with multi ajax events but you could try the following: set an ajax event on the listbox entry. onchange and set a global variable. In the query you use the global variable in the query. In the definition of the listbox you scroll down to the ajax refresh section, set checkbox and selectd the field to refresh.
I am also not found the document in this forum.
I decided to change the database table definition so it would be easier to get the dependent listbox values and use them in the query.