3 level dynamic dropdown list

Hi there, Im creating a seach page that will involve a user to select from a dropdown:
Hotels by Country
Hotels by City
Hotel names

All of the above are dynamic and currently I am using 1 database table to store the country, city, hotel name. (as well as details for the hotel).

I am a bit confused with the dynamic array help file and just would like a little more clarification for the approach above.

So hotels are filtered from hotels by city. and hotels by city are filtered from hotels by country.

is this possible using 1 table in my database?

it's possible but the concept is a little convoluted. basically, you need to create relations on the fly by using CONCAT in your recordset.

you need 3 recordsets:

rsCountries
SELECT country from tableNmae

rsCountryCities:
SELECT country, city, CONCAT(country,'',city) AS countryCity FROM tableName

rsHotels
SELECT hotel, CONCAT(country,'',city) AS countryCity FROM tableName

for the first select list, use the rsCountries recordset, use the country column as the label and the value.

add the First Dynamic array behavior using the rsCountryCities recordset. the parent ID will be the country column, child ID is the countryCity and child value is the city

in the second dynamic array, use the rsHotels recordset, the parent is is the countryCity column, the child id and value use the hotels column