Thank you Steve.

I wrote the following trigger:

alter trigger utr_caseworker on h8summ

for insert as

update new

set hcaseworker = mst.hcaseworker

from h8summ new

 join inserted i on i.hmy = new.hmy

 join h8summ mst on i.hmastersum...