|
I have Customers table like CustomerID, CountryID, CityID, VillageID. and also Country, City and Village table.
I want to enter data to Customers table. When entering data, user choose Country, City and Village by ComboBox and these comboboxes are filled by releated tables Country, City and Village.
Moreover, when user choose Country, there should be only releated cities at City ComboBox. Also village will works same.
If I fill customer table before filling country, city and village table, combobox selected values are wrong. I mean Country combobox dont show correct CountryName according to Customers.CountryID. For these reason I must fill Country, City and Village tables before filling Customers tables. But now, all cities are shown, I need to show only selected country's cities.
My problem is how can I use releated combobox data binding? |