We are a manufacturing plant and I created a Filemaker application to create production form.
I have the final product in a table and a raw materials table.
I Create a portal with calculation to know the receipe or the breakdown of products to be create on the production line.
So example, my product is a Chocolate cake, I have the breakdown of materials so:
So my calculation is like
Everything work well, but, when i have to create the same products for an other time the calculation stop to work and replace the numbers by the previous products made.
There is a way to create a calculation independent per record?