>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.

As Craig said, the child record PK is the one you change. The relation from the child to the parent is in the Child.ParentFK field (a foreign key pointing to the parent's primary key). Does it make sense?