Situation:

Datagrid with two dropdownlists and some other boring values
The list are: 'company' and 'project'


What I was trying after picking a company then update the 'project' dropdown
(filter the dataview that holds the values) with only the projects of that
specific company.
Well, that worked! Here is how I did this.

Code:

AddHandler dtContent.ColumnChanging, AddressOf
Project_ColumnChanging



Now the problem: it worked too good!

If I do this in the a specific row, all the other rows (with other
companies) the project-dropdown will display a null value.
I understand WHY, but can someone tell me how to prevent this?
I was looking perhaps for something with the nulltext-value (because the
dropdownfield is showing the nulltextvalue) but can really put my finger to
it...