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.
Options Menu with SQL
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
-
- Posts: 746
- Joined: Sun Feb 04, 2007 11:01 pm
- Location: McKenna, WA
Re: Options Menu with SQL
Hi,
Just put the data from the username search into the option button.
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.
Just put the data from the username search into the option button.
Code: Select all
put theNameList into button "myButton"
Tom
MacBook Pro OS Mojave 10.14
MacBook Pro OS Mojave 10.14
Re: Options Menu with SQL
Thanks quail! Much appreciated, works perfect.