Help in my Stock Calculation

[IP C]

Hello All,

 

Its been 2 months since I started using Filemaker. Now this is my first post. In the attached file Im trying to make something like Bill of Materials. I have a Product Table, Stock table and Components Table. The relationship is Below

 

My Problem is when I update my Stock table using a portal in my Popover it always shows the balance to my Stock Portal. What I want is It will show the Individual Stock as I choose each Product.

 

Please help me correct my mistake & Please see attached file for reference.

 

Thank you so much in Advance.

Product Allocation.fmp12

[Fitch]

Welcome to the forums. Can you maybe give a more specific/step by step example of what you're expecting to see? I'm not sure I understand the question.

Meanwhile, have a look here:

http://filemakerinventoryresources.com