I have a Search page that I am working on. There are two tables. The first is called state and the second is called schedule.

I have two drop down menu/list fields on the screen. If they select a state in the first field, I want it to use this state as the filter for the second drop down menu/list.

Is this possible?

Right now, if I tell the second recordset to filter based on an a form variable, the drop down menu contains nothing. But if I don't filter it then I get all the ClubNames listed for all 50 states.

Thanks for any help

sounds to me like you would have to have the second dropdown list on another page, which has a recordset from the schedule table filtered by the state selection from the previous page, if you know what i mean.
this second page could look exactly the same as the first, except it has a different recordset.
I may be wrong, I am a newbie, there may be a different way.

Dave

please look here for filtering dynamic on dynamic values:
www.macromedia.com/support/ultradev/ts/documents/client_dynamic_listbox.htm

please look here for a tutorial which refreshes the page, thus forgets any data filled in in form objects:
www.udzone.com/ShowDetail.asp?NewsId=3218

Or download this extension which can filter dynamic child items through a STATIC parent list box:
www.kaosweaver.com/Extensions/Dropdown_Rewrite/

If anyone can help me with my problem then i'll consider sharing my dynamic dropdown extention.

With kind regards,

Dennis van Galen
Webmaster KPN Services
Financial and Information Services