Here is one you could use. It is not a custom tag, but not near as difficult to format your html around it either. Just modify your queries etc...
<cfif isDefined('form.select_Main_Group')> <cfset page.select_Main_Group = form.select_Main_Group> </cfif> <cfoutput> <form name="DropDown" method="post"> <!--- query DB for the first drop down list ---> <cfquery name="get_Main_Group" datasource="xxx"> select categories.cat_id, categories.category, categories.parent_id from categories where categories.parent_id is null </cfquery> <!--- first drop down list ---> <!--- NOTICE the onChange javascript event in the select tag, this is what submits the form after the first selection ---> <select name="select_Main_Group" required="yes" onChange="this.form.submit()"> <option></option> <!--- dynamically populate the first drop down list based on the get_Main_Group query ---> <!--- NOTICE the CFIF within the option tag, this says, if the first selection has been made, display the chosen option when the page reloads ---> <cfloop query="get_Main_Group"> <option value="#cat_id#" <cfif isDefined("form.select_Main_Group")><cfif form.select_Main_Group eq "#cat_id#">selected</cfif></cfif>>#category#</option> </cfloop> </select> <p> <!--- if the first selection has been made, display the second drop down list with the appropriate results ---> <cfif isDefined("page.select_Main_Group")> <!--- query DB for second drop down list, based on the selected item from the first list ---> <cfquery name="get_Sub_Group" datasource="xxx"> select categories.cat_id, categories.category, categories.parent_id from categories where categories.parent_id = #form.select_Main_Group# </cfquery> <!--- second drop down list ---> <select name="select_Sub_Group" required="yes" onChange="this.form.submit()"> <option>Select Subgroup</option> <!--- dynamically populate the second drop down list based on the get_Sub_Group query ---> <cfloop query="get_Sub_Group"> <option value="#cat_id#" <cfif isDefined("form.select_sub_group")><cfif form.select_sub_group eq "#cat_id#">selected</cfif></cfif>>#category#</option> </cfloop> </select> </cfif> </form> </cfoutput> ----- Original Message ----- From: "Bobby Hartsfield" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Wednesday, September 06, 2006 2:21 PM Subject: RE: dynamic related select box > I like to write my own related selects but look for CF_TwoSelectsRelated by > Nate Weiss (there are also others that will relate more than 2 selects) > > ..:.:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > > > > > > > -----Original Message----- > From: Ali Majdzadeh [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 06, 2006 3:03 PM > To: CF-Talk > Subject: dynamic related select box > > Hi everybody: > I need a solution for dynamic related select box. For example when the user > selects the state in the other select box all the cities of the selected > state appear. > Do you any free/easy way to do that. I use coldfusion/ms access. > Thanks > Benign > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252273 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4