I have a db table that has a store name, store number, unique ID field & address info. On my webpage I would like to have store name populate the first dropdown menu, which I have working (I am using the DISTINCT Sql method). Then on select of a particular store name I would like to populate the second dropdown menu which would pull all store numbers that are equal to the store name selected in the first dropdown. Then once a store number is selected I need to populate a text box that would hold the unique ID and the populate fields that would hold the store information such as address, etc. Any ideas?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Dynamic dropdown menu's?
- Thread starter mkiv
- Start date
run your query to get all the detail rows, and sort by store name then store number
use CFOUTPUT GROUP=storename to populate the store name dropdown, and a second CFOUTPUT with a nested GROUP=storenumber to load the second dropdown's options
use javascript to manage the dynamic population based on selections -- see
Universal Related Popup Menus
rudy
use CFOUTPUT GROUP=storename to populate the store name dropdown, and a second CFOUTPUT with a nested GROUP=storenumber to load the second dropdown's options
use javascript to manage the dynamic population based on selections -- see
Universal Related Popup Menus
rudy
- Status