why not just do it at time of selecting the custom record on the sales order (i.e. after field edit)