I use SET KEY when I want to view child records for a particular parent without creating a view. It is *blazingly* fast.

>Hi All.
>
>I just want to gripe about the fact that filters and grids are still apparently a problem in VFP 6. I think it really stupid that I can open a large table and set a filter and browse brings up the data in seconds while a form with the same table in its data environment with the same filter and a grid connected to the same table takes minutes.
>
>And don't anyone tell me to use a view. I already know that and that is not the only answer to application development. If it was, the BROWSE command would never have been Rushmore aware and Rushmore optimization would never have been invented and LAN based applications would never have been made without a database server backend.
>
>Thanks
>
>Mike Yearwood, GE Capital Consulting