>I am using a table with optimistic table buffering. I am trying to append from another table. Every time I try this I get 'Uniqueness of index myindexname violated. The records that I am adding do not exist in the table I am appending to.
>
>Can anyone help or explain?

The index tag myindexname is set up as either a candidate or primary index; this means that no two records are allowed to have the same value in the table at the same time. It's possible that there are either records matching the key of something you're trying to add, records that you're trying to add that have a duplicate key, or if you're appending records that don't have the necessary fields already present, then multiple records with an empty index expression are being generated during the append.,