Well there are two main ways, either you get all data first and manipulate
on the client or you make a call to the database each time an item is
selected in one of the first two lists.
If you don't have too much data then the first method is usually preferred,
if it's a lot of data then the second, what do you think applies in your
Can you also describe the scenario? Is it classic ASP, code running in a
Joe Fawcett (MVP - XML) http://joe.fawcett.name
"S N" <uandme72@xxxxxx> wrote in message
>I want to have three level dependent drop down lists:
> User chooses an option in dropdown 1.
> this lead to dropdown 2 getting populated as per options avalable related
> to the choice made in dropdown 1.
> similarly when the user chooses some option in dropdown 2 the dropdown 3
> gets populated with options related to the choice made in dropdown 2.
> The options for all the three drop down lists are available in MS Access
> Till the user selects any option in dropdown 1, the other two drop down
> remain unfilled and blank.
> Please advise on how to achieve it and is there any sample code available
> to achieve the above.