Hi Everyone

Firstly a Happy new year to you

To start off the new year I would appreciate your help with this major problem that we are facing

1. We have a DataGrid which is bound to the EmployeeDirectory table

This table has 2 columns in particular called

Department and EmployeeName

Our aim is to make Department and EmployeeName comboboxes in the datagridview such that if someone selects the 'Department' column, a combobox will show all available departments

Secondly if they select a department, the 'EmployeeName' column shows all relevant Employees in that department

We have a datagridview where the datasource =EmployeeDirectory  table.

The datasources of the  Department column and EmployeeName column  are such that datasource =EmployeeDirectory 

We have mapped the Department column and EmployeeName column respectively as the respective ValueMembers and DisplayMembers column names

We have hit the wall when programming the CellEndEdit routine of the DepartmentColumn and CellEnter routine of the EmployeeName

OUR STEPS SO FAR

1 ) We find the employees of the newly selected department using a sqlsearch you get a datasource  eg datatable

This is a new list different to the previous employeename combobox datasource.

PROBLEM

If you apply this to the EmployeeNameCombobox column, it actually applies it to every EmlpoyeeName combobox column of every row in the datagridview which raises an error

We want to apply individual datasources to individual rows

Can this be done

I appreciate your time