>Hi Nick
>
>How do I index the view? The only thing I see is the order by during a requery(). I don't like that idea,
>because it forces a requery() each time a different column is selected, and that can take too long if there
>are MANY records to requery().
You can index the view with USE myView and INDEX ON... TO just as any regular DBF.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison