dont have time for a full investigation but; you could read the posts on dynamic combobox I have done
Load your data into a DataTable then have a Dataview (or other filtering control) in the Table.
then use Validation on the column with the first combobox. Validation only because it will fire after the cell is edited. Then change the filter to your DataView during validation.
Warning: This information is not tested. And may in fact cause you to Derive a custom DataGridControl that uses a CustomDataRow exposing the ActualContent property of the a CustomDataCell (only if you have to use validation as a means to setting the dataview filter)
I have done most of this with much success and would be glad to share when I have the time. Unless you want to figure it out on your own to learn and grow as a developer
Imported from legacy forums. Posted by MiddleTommy (had 272 views)