Dynamic Lists

Hey,

I have a very good question. Ok, I have a form with two drop down list. I need the list items to vary by what I select. Ok..short and sweet. I have a list of dates in one....in the other I have a list of events. If I select a date in the first drop down I only wanna see the events for that day. Also if I select an event I only wanna see the dates for that event! What is the best way to go about doing this....and please dummy it down for me...I suck at sql to be honest!...lol.......

Go to this link:http://www.mattkruse.com/javascript/dynamicoptionlist/

Also, search this forum cause this is a common question.

thnx man...I looked on the forum but could find what I was looking for!

When you select a list item do you want the other list to be (re)populated with or without a page refresh?

A page refresh is somewhat "straight forward" in that you will be able to code some relatively generic functions that are called when the page reloads. This helps to keep your (client) page a little less bloated by only sending the required data to the browser.

If you need this done without a page refresh then you can either preload javascript arrays and deal with them in the client side code or track down other methods of executing server code from the client. (I've seen attempts at this a while ago ... it wasn't pretty then, perhaps it's a bit cleaner these days)

thnx...i totally againist java....I think I'll just keep looking into my sql string and my asp code..