>What I actually had (since replaced by your suggestion ...) was:
>
>for grid1:
>

USE MyTable AGAIN in 0 ALIAS MyTable1
>USE MyJobs AGAIN in 0 ALIAS MyJobs1
>SET RELATION to Jobidnum IN MyTable1 INTO MyJobs1

>Similary, for grid2:
>

USE MyTable AGAIN in 0 ALIAS MyTable2
>USE MyJobs AGAIN in 0 ALIAS MyJobs2
>SET RELATION to Jobidnum IN MyTable2 INTO MyJobs2

>Now, this failed, so all I trying to understand is why it does fail, as I thought using separate files like this gave me separate record pointers.
>
Hi Jim,

PMFJI, but I think the problem is you didn't use the ADDITIVE keyword when you set up the second relationship. This would release the previous relationship.

HTH,