>The index is set up as a primary key. I do not have any duplicate values, and all data is populated. How does the append from work, does is add blanks records according to how many you will be appending?
>
>I replaced the append from statesment with code that appends a blank, then stores all data to variables, the replaces the blank records with the variables. This works.

I don't know what goes on internally with APPEND FROM, but it sounds like, at least with table buffering set up, that might be the case.