Thanks Alan for responding. I tried reindexing, I dont have the exact message right now but the error said that this particular view cannot be index. In fact I am working on a similar approach with Cetin's help.

>Bhavbhuti, you can index a view. Open it without data, index it just like you would a normal table, and then requery it. Actually, you can index it anytime. I just like to do it without data because it's quicker.
>
>Alan
>
>>>Unfortunately, I cannot post all the code required to make that class work because there is way too much of it.
>>
>>That's all right.
>>
>>
>>>(IIF( SEEK( MyRecoursSource.MyKeyField, 'MyLookupTable', 'MyLookupIndex' ), MyLookupTable.Description, '' ) )
>>>
>>
>>Anyways, I have the thing based on a view and the seek idea won't work as the is not allowed to be index :(.
>>
>>
>>>Set the sparse property of the column to false.
>>
>>I'll keep this as last ditch
>>
>>
>>>If you must use a combo of style=0-drop down combo in the grid, hopefully you have subscribed to FoxPro Advisor. I had an article about a combo box in a grid class that handles this problem in the Febraury 2000 issue of the magazine called "Spice up Your Grid with a Combo". Here is the abstract:
>>
>>Any equivalant FoxTalk article.