First, thanks (No alltrim! DUH!) But even though I removed the ALLTRIM()'s, I'm still getting all records in the child table.

Second, I'm using IDX's cause legacy code is looking for IDX files.
Bummer, but for now it'll work.

Third, I have a typical one to many, and all fields from table1 and
table2 need to become a record in table3. So the second SCAN scatters
each record to a memvar:


SELECT Table1
SCAN

   ** Get's all of the first table's fields on the current record
   SCATTER MEMVAR

   ** Now loop through all child records and scatter each value to
   ** memvars
   SELECT Table2
   SCAN
     SCATTER MEMVAR
   ENDSCAN

ENDSCAN

** Table3 has only matching fields from tables 1 & 2 that I want
INSERT INTO Table3 FROM MEMVAR


See?