Change the PK field to a different value in the temp table before you append back in the records.
>I have a table that has a Primary index. Within my app, once I year I need to copy a selected number of records out of this table to a temp table, I then make some global changes to several fields in the temp file, then I need to append these records back to the original table.
>
>Before I even tried this the first time, I knew I was going to get a "Uniqueness of Index is violated" VFP error, and I did.
>
>Anyone have an idea of the best way to handle a situation like this? Is there a way to easily turn off the primary index, do the append, rebuild a unique ID, then turn the primary index back on.
>
>Any thoughts are appreciated.
>
>Mel Cummings
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer