Just curious...how would you handle this if the PK was used in a Parent-child relationship with another table? You couldn't just regenerate the PKs without re-establishing the previous relationships, right?

-Irv.


>>Craig,
>>
>>>Change the PK field to a different value in the temp table before you append back in the records<
>>
>>You mean to a value that would make it unique before I append it back to the original table?
>>
>>Mel Cummings
>
>That's exactly what Craig means. PK's should be surrogate keys anyway. Therefore the keys used are meaningless. Their only requirement is uniqueness. Just replace the temp file keys with newly generated PKs using your normal PK scheme and you are done.