>>Jay,
>>
>>The way I handle this situation is that I long ago I stopped using filters at all. I use SELECT to get the records I want in the cursor and order them the way I want them ordered. No filters, no variables to go out of scope, no THISFORM to get barked at by the SET FILTER condition, and only the records I want in the cursor. With Rushmore it is nearly as fast as a filter, even filters can get slow when using a grid to display the data.
>
>I was thinking of that, but then I ran into the problem in how to easily update the base table with any changes made to the cursor. Using the base table itself for the grid seemed the easiest way, but maybe not.
>
>UPDATE: Could I scan through the cursor and use the UPDATE command to update the base table? Have not done something like that before.
Jay,
If you cann use a CA then the updating can be made to be automatic for you.