7 Replies Latest reply on Jan 17, 2016 8:08 AM by DanielShanahan

    Inventory Numbers

    director@charlesmoore.org

      Good Morning...

       

      I have a simply database model that creates an inventory list for a project.  Items that can be added to the inventory include <model_base> which then generate a value list of <model_customized> choices. 

       

      I need some help conceptualizing the numbers and quantities.

       

      I have a portal in the PROJECT layout.

       

      How does one calculate the running total for <model_base>, dependent on the sum of the <model_customized> quantities?

       

      So that if I add  records

       

      <inventory_item-1008> and select <model_base-1000 Barcelona Chair> and <model_customized Barcelona Chair (green)>  ; quantity: 2

      <inventory_item-1009> and select <model_base-1001 Wassily Chair> and <model_customized Wassily Chair (green)>  ; quantity: 3

       

      The total quantity for

       

      <model_base for Barcelona Chair> should be 6

      <model_base for Wassily Chair> should be 9


      THANKS FOR ANY HELP!