....code after tables have been opened

SELECT Table1
SCAN
REPLACE Field1 WITH FieldValue IN Table1
IF SEEK(Field2, "Table2", 2)
IF Table2.Field1 = .T.
INSERT INTO Table3 blah blah blah.....
ENDIF
ENDIF
ENDSCAN

There you go, basically what it is doing.

Kev