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