Create a Control application with a Select Field.
Put whatever in the SQL to get it to create a drop down list.
Check the box for: Reload form when value has changed
Save it and generate it.
Now click to edit the Field again. If you want to turn off this features the checkbox no longer appears.