>
>You can;
>
>SET FILTER TO ...
>
>SET KEY TO ...
>
>SELECT * FROM TableA WHERE Key = ... INTO CURSOR Results
>
>Create a parameterized view in a databse and then;
>
> ParameterVariable = KeyValue
> USE TheView
>
>Or a number of other options.

the set key command looks favourite. Thats a new one on me. The filter and query options are far too slow once we're using large tables. Thats why we gave them up in FP2.6 and created appropriate indices instead.

But also see my previous reply - the opening of the second instance of the table in the relevant key order and making it the recordsource for the grid does seem to do the job.

Many thanks

Harry