director@charlesmoore.org

Inventory Numbers

Discussion created by director@charlesmoore.org 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


THANKS FOR ANY HELP!

Attachments

Outcomes