Multiple dropdown menus - Parent, Child, Grandchild

I'm trying to setup multiple dependent dropdown menus... in this case Continent, Country, State, City, etc. Using the 'Getting Started' documentation I have the Continent and Country menus working just fine, but when I go through the procedure again to setup the State menu the dynamic array (rsCountries) is overwritten by the dynamic array (rsStates). So I have the Parent and Child working fine... it adding the Grandchild that I'm struggling with. Can someone explain how to setup the Grandchild menu?

Much appreciated,
Patrick

There is not a limit to the dynamic arrays, you can have two of them on the page at once without issue. Please describe in detail the steps you are taking to add your dynamic arrays to the page so we can determine if there is an error some where.

Unless I'm missing something, I believe I'm following the "Getting Started" guide to the letter.

1. First I create 3 recordsets: rsContinents, rsCountries, and rsStates.

2. Next I set add the 3 menus to the page: Continent, Country, and State and make the Continent menu dynamic by tying it to the rsContinents recordset.

3. I then create the dynamic array "Create Dynamic Array (rsCountries)". Then I select the Continent menu and populate it from array. At this point I have a working Continent and Country menu.

4. I then repeat #3 above except Country is the parent and State is the child. I create the dynamic array "Create Dynamic Array (rsStates)". Then I select the Country menu and populate it from array. Unfortunately, at this point the State menu does nothing. Not sure why.

Thanks,
Patrick

Ok, so when you are creating the second dynamic array you are able to have both on the page at once correct?

If you have the create dynamic arrays and populate list from arrays on the page then that part should be ok. You may be experiencing a problem with the relationship of the countries to the states. How do you have this relationship defined in your db?

If you could post back with the three tables in an sql file I could check on it and do a test to help determine what the problem may be.

Eric,

Yes, I am able to have both dynamic arrays on the page at once.

Please find files of interest attached.

Thanks for your help,
Patrick

I did some testing on this and created a page like yours and was able to get it to work as expected. What I think is happening is that when you select the continent it is defaulting to the United States. Since the populate list from array is applied to the onChange of the county select list the states will not be selected unless a change is made to the country select list.

To account for this in your populate list from array behavior applied to the continent select list update it and in the Target list options enter 1 for the leave top. This will make it so the user must select either one of the choices and when they do the states list will populate automatically.

On your page if I choose Canada it will populate with the Canadian states, if I then select USA it will populate with the US states.

Hi all,

I tried the dynamic dropdown with 3 list menu's and it works, however when you populate your choices in all three list menus and change the first list/menu selection it will not update the third list/menu. The third updates when a change is made in the second list/menu. I think this should not be or am i doing something wrong?

I think maybe this is the reason why it is stated that dynamic dropdown is made to work with two list/menu items only, or not?

Thanks

the third drop down wont be effected by the first dropdown, unless you add another onchange event to the first dropdown to change the third dropdown.

add another popualte list from array behavior to the onchaneg event to the first dropdopwn to manage the third one.

Dear Jason,

Will this not result in the third dropdown being populated without selecting anything in the second dropdown? If so then i think it is also not correct.

I have seen multiple dropdowns where the second and third jump back to their default "choose" value when the first dropdown is changed but i have to state they used AJAX technology to update all dropdowns. So i wonder if it is possible to create the same effect with Dynamic Dropdowns.

I will give your suggestion a try later to see what happens.

Thanks.

you could use the set selected in list behavior on the onchange event of the first list to set the third list to the default empty value.