>Thanks Sergey, you did it again <g>

You're welcome. BTW, in VFP8 code could be even shorter.

* Add records to table2 from table1
INSERT INTO table2 ;
SELECT * FROM table1 ;
  WHERE keyfield IS NOT IN ( SELECT keyfield FROM table2) 
* Add records to table1 from in table2
INSERT INTO table1 ;
SELECT * FROM table2 ;
  WHERE keyfield IS NOT IN ( SELECT keyfield FROM table1)