I have a VFP8 application that includes grid controls on forms that are bound to a table that has 4 million records and is over a gigabyte in size. The grid controls work very well for users to view and edit the data.

While the users can find their data easily with a SEEK command, I would like to add the ability to filter the data based on a user specified criteria.

Obviously SET FILTER is out of the question with a table of this size, but at the command prompt a simple BROWSE FOR table.field = "xyz" for the commonly needed filtering works very well with the indexes that I have.

Is there an way to get the same Rushmore optimized filtering in a grid control?

Thanks,
Jeff