Inventory Numbers

Discussion created by on Jan 16, 2016
Latest reply on Jan 17, 2016 by DanielShanahan

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