>I'm a firm believer in never putting more records in a grid than the user will be able to comprehend. I'm in process of upsizing a VFP system (not my original design) that has the same problem.
>
>My approach is to set up filtering criteria (the WHERE clause) before the data is selected and before the grid is displayed.
>
>Restrict by date range, client name, or something that will immediately bring the dataset down to a manageable size and speed. THEN show the grid.

I'd like to do the same, but this should be transparent to the user.. the system should work behind the scenes.
The final result anyway should produce a grid with all the records.
This is a need for my users.

I'll keep to play with Asynchronous mode and see the results.

Thank you.