help with getting values from subform and updating other forms

help with getting values from subform and updating other forms

Subject line is not too good, here is what I want to do. I am building an inventory system that will include components (bottom level part) sub assemblies (made from components) and assemblies (made from sub assemblies and components)

What I have now is a sub form in an assembly form that allows me to pick components and assign how many are needed for the assembly. I also have a form field to input the number of assemblies being "built"

Now what I need to do is grab the number being built and multiply it by the number of components needed per assembly and subtract that from the number on hand of that component.

I am new to Zoho, but not to coding in general. Can someone please point me to the referance material to learn this from or just give me a script example to do it?

Bert - New Zoho creater :)