>Thanks Ko for your answers..
>I think I havn't explaines my self well...
>
>I have the same table on remote sites, I want to unite the data together on a central station. I have a primary key on the "jobno" field. I use the APPEND FROM to a zapped empty table, and on the first append I get the unique key violation.
>
>I'm not sopposed to have duplicate values because each site has it's own set of numbers.
>
>In hope to get more good advice,
>Thanks,
>Gadi Hutt

---

Then it should work, but are you sure that you have the same field lenghts on both the 'client' side and the 'server' side?
And is there a primary key index on the 'client' side too? If not then you have the change that the clients data isn't unique.

HTH