Not sure why you posted this in the Filemaker Server forum instead of the Using Filemaker forum, but here's your answer:
Use the Sum() function in a calculation field defined in the table for Database #1.
Should compute the totals you want.
I felt stupid posting such an easy question. And now more stupid for posting it in the wrong area. But the solution was easy and spot on. Thank you.
It's a moldy old quote but "the only stupid question" is the one you didn't ask." :smileywink:
And folks post to the "wrong" forum all the time. We even get Bento user posts here once in a while. It's not a big deal, you just might not get a response as quickly if you put one up in the wrong place.