table 1 contain accumulated data,table 2 contain new data,
if table2.customer_no =table1.customer_no delete from table2 .. append table2 to table1
thanks.
In VFP8
INSERTINTO table1 ;
(SELECT * FROM table2 WHERE customer_no NOT IN (SELECT customer_no FROM table1)
* DELETE FROM table2 && generic* ZAP IN table2 && if you have exclusive access* USE IN table2 && if it is a temp cursor