>>Probably you have deleted records in the table you are appending too.
>>And if you want to overwrite all the current values you also have duplicate keys.
>>You can zap the dest table first before you append from the source table
>
>Hi Ko,
>I performed a pack command on that table, because I only want to ADD records to it, and still I get the same error.
>What will be the consequences if I'll change teh primert ket into a regular one??
>
>Thanks,
>Gadi

---

Gadi,

Another problem can be that in the table you are appending from there are deleted records with the same id's as in the dest table.
vfp appends them too, and unmark them for deletion.
The best you can pack both the dest table and the source table before you append.
If you are sure that there are no duplicate records left then you can normally append the data.
If you are not sure you can do two things.
check all the data (could be done with one sql statement)
or set your index to unique so that only the first record is visible.