Show total of matching records from related table

[lalcorn802]

I have a database for tracking budgets, amount spent, and balance. I have a layout that I show information about each account. I want to have a field that will total all amounts written out of that specific account. How can I show that amount in a specific field. For example I have an account for the warehouse supplies. I want to have a field that shows a total of all the purchase orders that was written out of warehouse supplies.

[aaa]

Hi, Lalcorn802.

Can you attach the screenshot of your layout?

[lalcorn802]

Here is a screen shot from the account table

[aaa]

Ok.

Purchases table must have account number and amount.

Create relation from Accounts table to Purchases table by account number.

Then use Sum(Purchases::Amount) function.

This is not exactly answer, because i dont now definitions of your tables and fields in the tables.