>In this case the PARTID has a unique property. If you add a surrogate key, the PARTID still has to be unique in the table (Why do you want two records with the same PARTID ???).

Ahh, I see. I just wasn't sure what you were getting at from your other post.