Options Menu with SQL

Creating desktop or client-server database solutions?

Moderators: Klaus, FourthWorld, heatherlaine, robinmiller, kevinmiller

Post Reply
smith8867
Posts: 57
Joined: Tue Nov 18, 2014 5:36 pm

Options Menu with SQL

Post by smith8867 » Sat Mar 12, 2016 3:46 pm

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
Posts: 746
Joined: Sun Feb 04, 2007 11:01 pm
Location: McKenna, WA

Re: Options Menu with SQL

Post by quailcreek » Sat Mar 12, 2016 5:29 pm

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.
Tom
MacBook Pro OS Mojave 10.14

smith8867
Posts: 57
Joined: Tue Nov 18, 2014 5:36 pm

Re: Options Menu with SQL

Post by smith8867 » Sun Mar 13, 2016 12:55 am

Thanks quail! Much appreciated, works perfect.

Post Reply

Return to “Databases”