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.