>>If you can use cursors for the grids, you can do the indexing (which is temporary) right in the header click, so there isn't any wasted indexing...
>
>I use a mixture of cursors, tables, and views, so I could do that some of the time.

You can do same with tables & views, but it's more work especially with buffering on. Small tables can go to a local cdx using OF clause of INDEX ON, or can be pre-indexed. Large tables shouldn't be in grids, anyway. Views can be indexed "spontaneously" like cursors, but you may need to check for updates and change buffering status to 3. I find it's easier to index the needed view fields ahead of time, in form Load, usually.