>But won't I have to pull the values from the server using server side script? If that is the case, on my onchange event of my dropdown, I have to access the server but the event I am calling is client side script.
>
>I think I am confusing myself even more.
>
>Any suggestions on how to look at this thing?
>
>Thanks
>Jason
If the data would be pulled from a server than IMHO a good approach is to use a parameterized view. You would add the view with NoDataOnload and set it as rowsource for second combo.
You could create your view with say - where somefield = ?m.runtimevalue. In lostfocus of first combo or gotfocus of second combo you could requery the rowsource (interactivechange could be too much repetition for a server download) :
m.runtimevalue = thisform.firstcombo.value
requery("secondcomboview")
Other than that I think folks doing ASP could help better. Visit
www.west-wind.com too and better sign-in for the forum there.
Cetin