>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.
Thanks Jim, I will give that a go. The changing from BUFFERING 3 to 5 around the index, has to do with what? Over coming a bug?
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope