I have the following code:

SELECT 0
USE Table2
INDEX ON ALLTRIM(Field1) + ALLTRIM(Field2) TO MyIndex

SELECT 0
USE Table1
SET RELATION TO ALLTRIM(Field1) + ALLTRIM(Field2) INTO Table2

SCAN

SCATTER MEMVAR
IF NOT EOF("Table1")

SCAN

** some code here

ENDSCAN

ENDIF

ENDSCAN

Everything seems to work fine. The tables and index are set up ok, and the
relation is fine.

Except that when I run it, all records in the the child table are being hit.
If I browse Table2, I dont see the matching records until I browse Table1, but the data session window shows the relation. It's almost as if browsing them refreshes it somehow.

What gives?