How to record in database the result of a third cascading drop down

[joezart]

I have created a table called
LOCATION
with 3 fields
countrycounter: auto incremental integer as primary key
Country: to record countries
staprov: to record state or province

Also I have created another table called
INTRESTAURANTS
with some fiels as
restcounter: auto incremental integer as primary key
typeoffood: chinesse, vietnamise, indu european, etc.....
name: name of the restauran
category: Luxury, popular, etc...
countryid to record countrycounter

On the second table I need to record the location of the restaurant, so
I created a list using the respective "data and link to table" and joined
to the first one

LOCATION/countrycounter = INTRESTAURANTS/countryid

I'm using a database join element to populate the country from the first table (working good)

A First cascade drop - down to populate and filter state or province having as the "watch element" the above mentioned (working good)

A second hidden cascade drop- down to populate and filter the countrycounter having the first cascading as the "watch element" in order to get the countrycounter. (working good)

However the second cascadingdropdown will place 2 choices:
(a) please select and option
(b) the filtered countrycounter

As this is a hidden element I need to able to place the (b) option at once so can be saved into database


How can this be done


Thanks

 

[joezart]

I solved the issue myself

I just have finally understood the concept behind the cascading drop down list.
You can link as many as you want as you could see my case.

But for the final one in the last cascading you need to get into it's administration setting, look for "show please select" and and click on NO.