>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.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope