Options Menu with SQL

[smith8867]

I am looking to create a drop down menu with a list of data from a query. Basically, submit a query on the table and get a list of the data in the options menu. For example, searching for "username", the options menu will be:

- Joe Bloggs
- Sarah Winters
- Andrew Windsor

Then is Joe Bloggs is selected, I can display information about that user. I was wondering how I could create this dynamic options menu, if possible.

[quailcreek]

Hi,
Just put the data from the username search into the option button.

Code: Select all

put theNameList into button "myButton"

Then in the script of the button do another database query using the chosen name and parse the data to where you want it displayed.

[smith8867]

Thanks quail! Much appreciated, works perfect.