Dynamic Dropdowns

I have a page called "Standings", I'm trying to create 2 Dynamic Dropdowns. The first is for Seasons (2008,2009,2010 etc.), the second is for Age Groups/Divisions. The goal is to have the user select the appropriate season and then the appropriate Age Group/Division and have the standings table appear. I'm a novice at this and I'm struggling to get past this issue. Thanks
Larry

Hello musloffice398578 this is an easy task to do the first thing is how do you have built your tables example

Seasons Table
idSeason int 11 auto_increment
SeasonYears date

AgeDivision Table
idAgeDiv int 11 auto_increment
idRelSeason int 11
LabeCell varchar 255

Standings Table
idStandings int 11 auto_increment
idRelAgeDiv int 11
OtherCells varchar 255


Then on your page you have to create your recordsets for each table this would be 3 recordsets

then create a drop down for each

and for last you would have to create 2 2 dynamic arrays from the drop down behavoir

and from here you have to construct with the behavoirs wich will be parenet and child of the others in secuence, if you give me a better example i can build a small help for you try pasting here the tables

Thanks for answering my request. If it's not too much trouble, could you go to the website listed below. This will show you exactly what I need. Thanks

www.musl.leaguerepublic.com

ok i see first you have it wrong having a link list for each, remove the links each list have or the command to make them go to an url, leave it that when the user press go or maby on the last list.

Ok first build the dependant list seasons and divisions follow the how to on the dynamic_dropdowns_gsg.pdf i think you have to log to your account to read this after you get the season with Divisions done, add a new list add the correct recordset for it (Compititions) and apply to the new last list the dependant drop down behavoir again that its dependant and that it would be child from the division list that is already child of the season list remeber that Division needs an internal id field in teh database wich will store the parents id from season and same for the compitition list but that extra id should hold the divisions as parent.