>>or how do you set an index in a view?
>>
>>I've created a local view and I need to move the pointer to a record. I'm getting the 'Table has no index order set' error.
>>
>>TIA
>
>The others have shown you how to index a view so you can use SEEK. This is a good method, and I use it all the time. But if all you need to do is to move the record pointer in a view that contains only a few records, it would be easier (and probably faster) to just use LOCATE FOR
And much more versatile, since you can do LOCATEs on things without having thunk up how to build the right index ahead of time, too!