Re-Bind a Combo-box by other in same datagrid

[Mr.Access]

I have a datagrid of three columns;
1. Comb-box1 : Employees' Names (DataSource : EmployeeBindingSource)
2. Comb-box2 : Coming Departure. (DataSource : DepartureBindingSource)
3. Text-box : ...............

* How can I filter or re-bind the source of the second one as the first one value changed (Both are in the same datagrid).
>> So as I select an Employee I need the second one gives me just the specific departures of the desired employee.Where I have the (Employee_No) field connect the two tables related to each one.

Your suggestions are highly appreciated.

 

[tehNellie]

I tend to bind the second combobox to a DataView filtered on what the user selects in ComboBox1, Employee_no in your example.