Update subform field from the line item's lookup value

Update subform field from the line item's lookup value

Hi Everyone,

I'm trying to find the right way to update a field on a line item of a subform from the lookup of that line item.

I.E I have record with a subform of products and pricing. When i create a line item, it copies the price out of the item, but if the item price is updated in the product, that's not reflected in the subform line.

I would like to be able to call a script that refreshed every line item and grabs the price out of the lookup and puts it in the subform price field.