Forums

triple drop down with AJAX

marklandry 09 Dec, 2013
Hi,
Got the double drop down with ajax (this faq:http://chronoengine.com/faqs/58-cfv4/cfv4-elements-and-html/2647-how-do-i-build-a-select-drop-down-radio-button-or-checkbox-group.html) to work but In need of one more dropdown (a triple dropdown in all) and can't get it to work

The first dropdown chooses "Class_ID"
The second pulls up all the dates that "Class_ID" is offered
The third should pull up all the time slots that "Class_ID is offered on this particular day.

In the third dropdown I keep getting all time slots listed in the database, as opposed to only the time slots associated with the specific "Class_ID" and date selected.

Not sure where to go from here - I tried adding the second dropdown's value in the multi record loader where clause for the third dropdown but can't seem to get that right.

Thanx for your help!!!

Mark
GreyHead 09 Dec, 2013
Hi Mark,

The second Ajax call needs to pass back both the selected parameters and you'll probably find it simpler to hand-code the query in the Ajax event instead of using a DB Multi-Record Loader.

Bob
This topic is locked and no more replies can be posted.