2 combobox master-detail

Hot Topic

changing screen resolution for two monitors
Visual Studio 2005 Express - UI Design View Error
Problem with Graphics
Saving information to a SQL database from a VB form
read webpage,,,help??
Please direct me to the right place...
Let's go to work on an FAQ for this Forum
How can I import data from Excel into VB Express?
Visual Basic Excel Project
How to use the timer correctly?

VS Express Editions

Need help with for and pictureboxes
Debugging problem
Import data (csv or Excell Spreadsheet) to existing table
Network Install / Educational
system lock of referenced assemblies
VB 2005 Express and .NET 1.1
VWD Couldn't be extracted
Two questions about ListBox
Custom wrappers
Should i use a generic Dictionary or a Collection?

2 combobox master-detail

i have three tables:

CountryTable: CountryId,CountryName,Description

CityTable: CityId,CityName,Description

I would hace tho combobox,the first one for Country and second for City

the second combobox (CityCombobox) should show only Cities that belong to the selected country on the first combobox (CountruComboBox).

i use a look up table :

CountryCity: CountryId,CityId

i have 2 relations:

rel1:

ParentTable=CountryTable

ChildTable=CountryCity

ParentKey=CountryId

ChildKey=CountryId

rel2:

ParentTable=CityTable

ChildTable=CountryCity

ParentKey=CityId

ChildKey=CityId

the 3 tables belong to dataset ds

CountryComboBox.DataSource = ds

CountryComboBox.DisplayMember = "CountryTable.CountryName"

CountryComboBox.ValueMember = "CountryTable.CountryId"

what are the settings (datasource,displaymember,valuemember) for the CityCombobox

I would the the CityComboBox show CityName !!!!

PLEASE help me !!!!

Answer this question

2 combobox master-detail

Answer this question