Hi Brian.

>I am still ending up with a corrupt ID field. My new key is definitely unique. I'm wondering if I have to append the same record to multiple tables to satisfy relations setup in Pervasive.

I'm guessing your corruption problems aren't Pervasive but ACCPAC. It's data integrity checking ensures that records in child tables have matching records in parent tables (among other things), so perhaps you're creating a record in a child table without the matching parent. What tables are you creating records in?

Doug