>I need to append from a table only those records I have not appended before. I have a unique field but just cannot find the proper way to do this.
>I have to append data from 3 remote locations into a local table daily
>without duplicating these records
>any ideas?
>thanks in advance..
>Dave Carter

You can use a SQL select to get the records you haven't previously appended and then append them from your temporary cursor.

select * from mytable where mytable.uniqueID not in ;
   (select uniqueID from targettable) into cursor c_temp
select targettable
append from dbf("c_temp")

HTH.