I would think that you'd need to perform ALL the possibly required queries and put them into a JS array, then depending on which was selected in the first select (use JS to check), populate the next select with the data from the appropriate array, and so on. I'm no JS expert and usually use http://www.irt.org/ to find an example to work from. Depending on the size of the queries, the page reloads may be the most practical. Although in this instance it seems that your queries don't return much so the JS option would probably be best.
Just my 2 cents - hope it's of use. Karl on 3/21/02 12:59 PM, Hammy at [EMAIL PROTECTED] wrote: > Hi all, > > I have a form that has 4 select boxes. The options in each select box is > dependent on the option selected in the select box before it. > > Any one know how to do this? > > I have a query that gets all the records and their parent group. > For example: > > id parentid name category > 1 0 root Root > 2 1 distribution cat1 > 3 1 sales cat1 > 4 1 customerservice cat1 > 5 2 shortages cat2 > 6 2 delivery cat2 > 7 3 returns cat2 > 8 3 promos cat2 > 9 6 undeliverable cat3 > > so in the first select box it will have 'distribution', 'sales', > customerservice'. > then, depending on which option they choose, the second select box will > be populated with > the items that have a parentid equal to the id of the first select box > choice. Then I want the third select box to do the same with the choice > in select box2. > > I am currently doing this by resubmitting the form to itself and > populating the next select box with what was chosen in box 1, but I > don't want to keep reloading the page. I want the select boxes to be > populated on the client side. > > Thanks for your help. > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: "Hammy" <[EMAIL PROTECTED]> > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ > This System has been donated by Infopreneur, Inc. > (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: Karl Zarudny <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
