|
 |  |  |  |  |  |  |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
 |
| |
03-23-2009
| #1 (permalink) |
| | Dependent dynamic dropdown lists-3 levels 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 |
My System Specs |
|
03-24-2009
| #2 (permalink) |
| | Re: Dependent dynamic dropdown lists-3 levels 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 Quote: >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 > |
| My System Specs |
|
03-24-2009
| #3 (permalink) |
| | Re: Dependent dynamic dropdown lists-3 levels "Joe Fawcett" <joefawcett@xxxxxx> wrote in message news:%23DTcjZFrJHA.4460@xxxxxx Quote: > 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? Quote: > Can you also describe the scenario? Is it classic ASP, code running in a > browser etc? Kindly advise relevant code/samples preferably ajax. uandme72 Quote: > > -- > > Joe Fawcett (MVP - XML) > > http://joe.fawcett.name > > "S N" <uandme72@xxxxxx> wrote in message > news:%23LUY6l9qJHA.4436@xxxxxx Quote: >>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 >> > |
| My System Specs |
|
03-24-2009
| #4 (permalink) |
| | Re: Dependent dynamic dropdown lists-3 levels "uandme72" <uandme72@xxxxxx> wrote in message news:%239YE5uIrJHA.3848@xxxxxx Quote: > > "Joe Fawcett" <joefawcett@xxxxxx> wrote in message > news:%23DTcjZFrJHA.4460@xxxxxx Quote: >> 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. Quote: Quote: >> 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. /Al Quote: > uandme72 > Quote: >> >> -- >> >> Joe Fawcett (MVP - XML) >> >> http://joe.fawcett.name >> >> "S N" <uandme72@xxxxxx> wrote in message >> news:%23LUY6l9qJHA.4436@xxxxxx Quote: >>>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 >>> >> > |
| My System Specs |
|
03-30-2009
| #5 (permalink) |
| | Re: Dependent dynamic dropdown lists-3 levels 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 Quote: > > "Joe Fawcett" <joefawcett@xxxxxx> wrote in message > news:%23DTcjZFrJHA.4460@xxxxxx Quote: >> 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. > Quote: >> 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 > Quote: >> >> -- >> >> Joe Fawcett (MVP - XML) >> >> http://joe.fawcett.name >> >> "S N" <uandme72@xxxxxx> wrote in message >> news:%23LUY6l9qJHA.4436@xxxxxx Quote: >>>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 >>> >> > |
| My System Specs |
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| Powershell and loading dependent assemblies | PowerShell | |||
| Distribution lists/group lists | Vista mail | |||
| Application-dependent internet speeds | Vista networking & sharing | |||
