I think you can do it with a query.

SELECT ;
		mast_id, ;
		incident AS run_num, ;
		date AS run_date, ;
		name_last, ;
		name_first, ;
		phone ;
	FROM master ;
	WHERE NOT EMPTY(msca_close) ;
		AND NOT EMPTY(msca_id) ;
		AND NOT EMPTY(disto)  ;
		AND date < (DATE() - 30) ;
		AND mast_id NOT IN ( ;
			SELECT mast_id FROM surv_sca) ;
	INTO CURSOR crsNew		
	
SELECT 	surv_sca
APPEND FROM (DBF("crsNew"))

>I think this is an easy one, but I have yet to figure it out.
>
>See the following code in my Form Init. The code scans records in a master table and adds records to a sub table if they are not already in the sub table.
>
>Whenever I run the form it adds records to sub table even if records already in sub table? Something is wrong with the SCAN FOR command. Thanks.
>