>Why is that not a good idea? Because my SET FILTER returns a small subset of records as you said.
>
>What would be a better approach?
May be in VFP9 it is not that bad, since it is supposed to be optimized. I was using grids and VFP6 and SET FILTER was a real performance killer.
If it's not broken, fix it until it is.
My Blog