Mark and the others have given you some good suggestions about using SPT. However, one advantage of Remote Views is that you can load the view with no data (See the NoDataOnLoad() method) and index it while it is empty. Then if you requery() the view the index is automatically updated. I do this in a SQL-Server app where I need several indexes for on-the-fly sorting.
Barbara
>I am new to using SPT and am wondering if the only way to index is to "INDEX ON whatever TO index"? I am using VFP tables now but I am using SPT to be able to use a different data back end in the future without modifying the code much. I need to set relations into my cursors I have created for reporting.
>
>Thanks in advance.
>
>Tommy