>Hi All,
>
>I had 3 Index order for a single table(ItemNo.,DocumentNumber,EpiryDate)
>
>I used set filter command in grid, what I need is how can I make Order by EpiryDate in grid ?
>
>Thanks For Your Time.
You can use SET ORDER TO [appropriate index tag here] and refresh the grid. See help for SET ORDER command
Also, filters on big tables can slow down your processing significantly. Depending on your situation, as an alternative you might try to use SQL statement as a recordsource for the grid. That may give you both filtering and ordering.
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