Ok Sam , I got your problem solved. Just do the following.
actually u have set orde to lastname and u are seeking on fname + lname , so how will u find it ???
inde on fname+lname tag name
>Hi Ajay,
>
>The following is what I did, However it doesn't check the duplicate record.
>Also the code works for the first time when both temp and annual database are empty. But when the second time come, where temp database now contain duplicate records for each record (double the size). And the code didn't check for dup, instead it just append all the records from temp database into annual database.
>
>Any ideas!!!
>
>
>select temp
>
>APPEND FROM d:\dean\ftp.txt TYPE delimited with |
>
>select annual
>set order to lastname
>
>
>select temp
>scan
> if !seek(f_fname+f_lname, "annual")
> scatter fields like * to t_array
> select annual
> append from array t_array
> release t_array
> else
> exit
> endif
>endscan