Hi,
I have 3 tables named
1-country(countryid,name)
2-state(stateid,countryid,name)
3-city(cityid,countryid,stateid,name)
and the table named address which have(countryid,stateid,cityid,street)
All 3 above tables are binded to grid as a combobox column.and address table binded as datasource to the grid everything is fine BUT
how can I relate first 3 combobox together when user select its country from first combo then state combo populate its related states automatically?
I have 3 tables named
1-country(countryid,name)
2-state(stateid,countryid,name)
3-city(cityid,countryid,stateid,name)
and the table named address which have(countryid,stateid,cityid,street)
All 3 above tables are binded to grid as a combobox column.and address table binded as datasource to the grid everything is fine BUT
how can I relate first 3 combobox together when user select its country from first combo then state combo populate its related states automatically?