you need to index on a FIELD in quotedet - not the view name iteself
>This is what I did in the init event of the form.
>SELECT quotedet
>CURSORSETPROP("Buffering",3,"quotedet")
>INDEX ON quotedet TAG part_num
>
>It says variable quotedet is not found.
>
>Any ideas?
>
>
>>>Is it possible to create an index on a view? If so how?
>>>
>>>Thanks
>>>
>>>Jim
>>
>>The same way as on table (you should set view buffering=3):
>>SELECT Myview
>>INDEX ON Myfield TAG Myfield
Ken B. Matson
GCom2 Solutions