>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?
Don't you have to put SELECT Table1 between the two ENDSCANs?