>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


Consider the Explorer interface in which the user can reorder the columns by clicking on the header. In a Set Key world, we'd have to build many indexes on each column by combining the column with the foreign key from the parent. This was never a problem with a browse, either (except that you couldn't click the headers...). Please try to see my real point, which is that if the browse can be Rushmore aware, then why isn't the grid?

Mike Yearwood, GE Capital Consulting