0 Replies Latest reply on Nov 22, 2015 6:58 PM by director@charlesmoore.org

    Sums in Related Tables

    director@charlesmoore.org

      I'm working on a database where users will add items to a project.  The items are from the <models_customized> table.  All customized models are related to a base model from the <model_base> table.

       

      In the <model_customized_JOIN_project> table, there is a field for the quantity of customized models.

       

      In the <project> table there is a field that sums the model_customized, adding up the related quantities.

       

      My question, is there a way to add a calculation field that automatically adds all of the <model_base> quantities?

       

      For instance, if I have a model_base = chair and a model_base = table.

       

      Then I add a model_customized (chair: blue) (qty: 2) and model_customized (chair:red) (qty: 3)

       

      Then I add a model_customized (table: white) (qty: 5) and model_customized (table:black) (qty: 4)

       

      I need a calculation field somewhere that tabulates model_base (chair) (qty: 5) and model_base (table) (qty: 9)

       

      Thanks so much for any help!

       

      See screenshot...