I want to have three level dependent drop down lists:
Meaning:
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
database.
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.



UANDME72

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
case?
Can you also describe the scenario? Is it classic ASP, code running in a
browser etc?

--

Joe Fawcett (MVP - XML)

http://joe.fawcett.name

"S N" <uandme72@xxxxxx> wrote in message
news:%23LUY6l9qJHA.4436@xxxxxx

>I want to have three level dependent drop down lists:
> Meaning:
> 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
> database.
> 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.
>
> UANDME72
>

"Joe Fawcett" <joefawcett@xxxxxx> wrote in message
news:%23DTcjZFrJHA.4460@xxxxxx

> 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 case?

I would like that you provide code for both the scenarios.

> Can you also describe the scenario? Is it classic ASP, code running in a
> browser etc?

My code is classic ASP, running on IIS server.
Kindly advise relevant code/samples preferably ajax.

uandme72

>
> --
>
> Joe Fawcett (MVP - XML)
>
> http://joe.fawcett.name
>
> "S N" <uandme72@xxxxxx> wrote in message
> news:%23LUY6l9qJHA.4436@xxxxxx

>>I want to have three level dependent drop down lists:
>> Meaning:
>> 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
>> database.
>> 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.
>>
>> UANDME72
>>

>
>

"uandme72" <uandme72@xxxxxx> wrote in message
news:%239YE5uIrJHA.3848@xxxxxx

>
> "Joe Fawcett" <joefawcett@xxxxxx> wrote in message
> news:%23DTcjZFrJHA.4460@xxxxxx

>> 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 case?

>
> I would like that you provide code for both the scenarios.

Lazy?

>> Can you also describe the scenario? Is it classic ASP, code running in a
>> browser etc?

>
> My code is classic ASP, running on IIS server.
> Kindly advise relevant code/samples preferably ajax.

Why not ask in an ajax newsgroup instead of a vbscript one?

/Al

> uandme72
>

>>
>> --
>>
>> Joe Fawcett (MVP - XML)
>>
>> http://joe.fawcett.name
>>
>> "S N" <uandme72@xxxxxx> wrote in message
>> news:%23LUY6l9qJHA.4436@xxxxxx

>>>I want to have three level dependent drop down lists:
>>> Meaning:
>>> 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
>>> database.
>>> 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.
>>>
>>> UANDME72
>>>

>>
>>

>
>

If you want to use Ajax then it's running in a browser, not on the server.
You then need to decide whether to use an existing framework or
roll-your-own or some mixture.
There are so many decisions here.
I suggest you search for "linked dropdowns Ajax" on Google, there are dozens
of examples there.

--

Joe Fawcett (MVP - XML)

http://joe.fawcett.name

"uandme72" <uandme72@xxxxxx> wrote in message
news:%239YE5uIrJHA.3848@xxxxxx

>
> "Joe Fawcett" <joefawcett@xxxxxx> wrote in message
> news:%23DTcjZFrJHA.4460@xxxxxx

>> 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 case?

>
> I would like that you provide code for both the scenarios.
>

>> Can you also describe the scenario? Is it classic ASP, code running in a
>> browser etc?

>
> My code is classic ASP, running on IIS server.
> Kindly advise relevant code/samples preferably ajax.
>
> uandme72
>

>>
>> --
>>
>> Joe Fawcett (MVP - XML)
>>
>> http://joe.fawcett.name
>>
>> "S N" <uandme72@xxxxxx> wrote in message
>> news:%23LUY6l9qJHA.4436@xxxxxx

>>>I want to have three level dependent drop down lists:
>>> Meaning:
>>> 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
>>> database.
>>> 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.
>>>
>>> UANDME72
>>>

>>
>>

>
>