AnsweredAssumed Answered

Summing a Field from a Related Database

Question asked by JackGeist on Dec 1, 2009
Latest reply on Dec 1, 2009 by philmodjunk

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 

Outcomes