3 Replies Latest reply on Dec 1, 2009 1:14 PM by philmodjunk

    Summing a Field from a Related Database

    JackGeist

      Title

      Summing a Field from a Related Database

      Your post

      I have two related databases.  #1 contains types of products and their costs.  #2 contains customers and products they have ordered and the number of those products they have ordered.  For example.

       

      Database #1

      Widget #1  $500

      Widget #2  $1000

       

       

      Database #2

      Customer A - 100 Widget #1

      Customer A - 1 Widget #2

      Customer B - 50 Widget #1

      Customer B - 2 Widget #2 

       

       

      In database #1, I would like to add a record that indicates how many total units of a product have been ordered by all my customers.  In other words I'd like to have an automated calculation that gives the following result in database#1

       

      Widget #1 - 150

      Widget #2 - 3