>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.
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry