Databinding to combobox - selected data causing issues

[drew4663]

I have two tables inside one database. Table1 contains company info. Table2 contains employee names. The admin is allowed to add employees to table2 and in a form table1 displays comboboxes and the employee combobox is populated by table2. The selected data from table2 is written to table1.

Thee issue I am having is the comboboxes are populating the data from table2 just fine but when I make a selection on one combobox it changes/populates the rest of the comboboxes with the first selection.

Example:
CamOp1 CamOp2 CamOp3
*John John John


CamOp1 CamOp2 CamOp3
*Jane Jane Jane

*If John is selected the rest reflect that selection

Instead it should be....

CamOp1 CamOp2 CamOp3
*John Jane Joan

I have the databounds properties set to....

Datasource: CamOpsDS (Table2 dataset)
DisplayMember: CameraOperators-->Name
ValueMember: CameraOperators--> Name
SelectedValue: CWCVD-->CamOp1 (table1 Dataset)

Datasource: CamOpsDS (Table2 dataset)
DisplayMember: CameraOperators-->Name
ValueMember: CameraOperators--> Name
SelectedValue: CWCVD-->CamOp2 (table2 Dataset)

Datasource: CamOpsDS (Table2 dataset)
DisplayMember: CameraOperators-->Name
ValueMember: CameraOperators--> Name
SelectedValue: CWCVD-->CamOp1 (table3 Dataset)


Any ideas???

 

[drew4663]

What I did to, sort of, fix the problem was make a dataset that contained all tables.