Page 1 of 1

Options Menu with SQL

Posted: Sat Mar 12, 2016 3:46 pm
by 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.

Re: Options Menu with SQL

Posted: Sat Mar 12, 2016 5:29 pm
by 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.

Re: Options Menu with SQL

Posted: Sun Mar 13, 2016 12:55 am
by smith8867
Thanks quail! Much appreciated, works perfect.