I have 1 dataset with two tables. One table is a list of states, the second table is a list of counties for each state. The goal is to have two comboboxes. The first combobox contains a list of states bound to the first table. The second combobox contains a list of counties driven by which state was selected in the first combobox.
Through code I can:
create and populate the dataset
create a relationship between the tables
bind the state table to the cmbState combobx
bind the counties table to the cmbCounty combbox
Through code I can't:
establish the relationship between the comboboxes. I get a complete list of states in the first combobox and a complete list of counties in the second combobox, not a list of counties for the selected states.
This is driving me nuts. I can do this through the use of the wizards; creating a connector, DataAdapters, dataset, a relationship, and set the appropriate datasource and the displaymember for the comboboxes but I can't seem to be able to bind the two comboboxes through code.
Help is appreciated.
Through code I can:
create and populate the dataset
create a relationship between the tables
bind the state table to the cmbState combobx
bind the counties table to the cmbCounty combbox
Through code I can't:
establish the relationship between the comboboxes. I get a complete list of states in the first combobox and a complete list of counties in the second combobox, not a list of counties for the selected states.
This is driving me nuts. I can do this through the use of the wizards; creating a connector, DataAdapters, dataset, a relationship, and set the appropriate datasource and the displaymember for the comboboxes but I can't seem to be able to bind the two comboboxes through code.
Help is appreciated.