Hi all. I am using Microsoft Visual Web Developer C# and am working with a database.
I am using 2 tables: CONTINENT table with fields: CONTINENT_CODE and CONTINENT_NAME
The other table is COUNTRIES with fields: COUNTRY_CODE and COUNTRY_NAME
The 1 dropdownlist is bound to the CONTINENT table and displays the CONTINENT_NAME (with its value CONTINENT_CODE)
The 2nd dropdownlist is bound to the COUNTRY TABLE and displays COUNTRY_NAME (with its value COUNTRY_CODE).
Now my question is what should you do in order for when a user selects Europe, England appears in drop down list and not China (vice a versa). Thanks