Update a Drop Down List from a SQL Query

[giorg90]

Hi guys,
I am using a Drop Down tool in my app. I would like to dynamically update the option list as the output of a SQL Query. For example, if my query produces a list of customer, I want the app allows to choose among all customers in that list.

How can I do it?

Thank you,

Giorgio

[MarqueeCrew]

Youtube post:  https://www.youtube.com/watch?v=0Wm8vIwnD6c

Youtube video:  

This post shows how to chain/link applications so that the first app reads the database and prepares the listbox to include relevant options in the second application.

Cheers,

Mark

[giorg90 · Accepted solution]

Thanks,

Actually we found the solution by selecting External Source in the drop down menu

And then typing the SQL query in "Properties" field