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