>>>>I have a grid based on a view that contains a listbox that displays a value other than the controlsource. The listbox is BoundTo a surogate key that is not displayed in the listbox (columnwidth = 0). Using Sparse = .f. the screen update is too slow and looks horrible. With sparse = .t., the grid displays the surrogate key.
>>>>
>>>>How can I diplay the same value in the listboox.displayvalue when the column does not have focus?
>>>>
>>>>Thanx in advance.
>>>
>>>I don't think that listbox will look good inside the grid. Basically, if you want to display some value in listbox differed from its controlsource, then you use e.g. 2-column cursor as listbox rowsource with surrogate key (controlsource) in second column and use Listbox.Boundcolumn=2
>>
>>
>>Oops, It's a dropdownlist! Which displays fine and is bound to the surrogate key. The dropdownlist is working fine when focus is on column. But the surrogate key is displayed when focus is else where.
>
>What is combo.rowsource ?

I am using a three column view where third column is surrogate key. The BoundColumn is 3.

I want to display (in a grid) the descriptive field related to a surrogate key, but store the surrogate key. I am using a dropdown list for user convenience. This is all working out side the grid and when the grid column has focus, but I want to display the descriptive field value in the grid when column loses focus.

Maybe there's a different way to approach the problem.