I have the following problem.

I have a grid with 2 dropdown lists (valuelists)

Whenever I set the value of the 1 cell, this will filter down the values available in the second.

What I do now is repopulate the valueList. 

However the problem is that once that is done, the others rows with different values in column 1 will not have the associated item to the column 2 value, and therefore the display member value will be missing and I only see the valuemember which means nothing to the end user.

My question is How do I keep the displayed member in the not active rows to show the description and not the ID.