>What does PK definition have to do with my question? (btw, I am too young to remember 1970 commercials)
It's an add-on comment for the solution.
For Naomi's solution to work (and her trigger code solution is a good solution), you need a primary key definition. Otherwise, you can't tie the rows in the inserted table (in the trigger) back to the original rows.