>>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,

There is also no SELECT MyTable 1 or 2, so the relationship is being set for the current workarea.

oooppppsssss.

Forgot to notice the IN MyTable piece of the SET RELATION statement.

Wish I could simply delete original post