Yes, BoundTo (difficult to reply without Help :), and it still bears some problems within grid. I mean it works 100% for isolated list/combo, and 99% for grid.column.combo

>With integers, it's probably related to that doggone BoundTo property.
>
>
>>Actually it works perfectly (I mean bound on surrogate key) for character key, and still involves problems (even with Bound=.T.) for integers. However, right-click menus work Ok.
>>
>>>A really goofy way to do this is to bind on the descriptive field (resolves what's displayed) and use a view and do a REPLACE on the key on LostFocus. This is what I've been forced to do in the past.
>>>
>>>>>>>I think that sparse property should do this. Also, there is really another way to do this job:
>>>>>>
>>>>>>Sparse shows the boundcolumn, which is the surrogate key. I don't want to display the surrogate key.
>>>>>>
>>>>>>I want to change the key value, but display the discriptive value.
>>>>>
>>>>>Currently, I use the next column to display the discriptive field. It's ControlSouce is bound to the surrogate key in the lookup view. I use the second view and set a relation to it to avoid having to requery every time the user changes the supervisor. I only requery after the user choses to do an update. The user can change many records before update.
>>>>
>>>>Sorry, the only thing I understand is that you set some relations. Whatever these relations are, you should not use them within a grid: they will give you tons of funny-looking problems.