Hi I have a problem and i need some help,

i have two entities 1 to many

Countries and cities.
so 1 country has many cities

i ve created a form with two listboxes

the fisrt listbox has all the countries and the second the cities

Now what i want is when i select a country from first listbox, the second listbox to show me only the cities of this country!!!

Country
IDcountry
Countryname

Cities
Idcities
Idcountry
Cityname


thanx a lot!!!!:)

The easy way would be a table with two columns: City and Country. Let's call the table CitiesInCountries.

In the City field, list all of the cities, and in the Country field what country the city belongs to.

Then in the first listbox's Change Event you need a query like this (to populate the second listbox):

__________________
Regards,
JP
JP SoftTech