>Bret,
>
>Put your view in the fomr's DE and mark it Nodataonload .T.. Then in the form's load do this;
>
>

>SELECT TheView
>CursorSetProp("BUFFERING",3,"TheView")
>INDEX ON YourExpression TAG Master
>CursorSetProp("BUFFERING",5,"TheView")
>Requery("TheView")
>

>
>This will give you an index on the view that is ordered the way you want the records to appear.

Another question, where will it place the index file at? I dont want to leave index files out there after the app is done.