I don't have any experience with coding and I couldn't figure it out. So...

I have a form called Materials_Catalogue which contains Description and Unit_Cost. The second form ( Resource_Costings) contains Resource, lookup field to Materials_Catalogue pulling Description and Unit_Cost, Quantity and Materials_Cost (Unit Cost x Quantity executed on User Input)

I need  Materials_Cost in  Resource_Costings to auto update itself when  Unit_Cost in  Materials_Catalogue is updated.

To simplify, when a price of a unit cost changes in the first form, the materials cost (unit cost x quantity) to be updated in the second form.

I am pretty sure that some kind of On Update>Fetch records and Update needs to happen but I can't compile the correct code.

Can anyone help me with this please? Cheers!