i have a fully working database in filemaker dev 6.

not i need to add something but cant find how to make it work.

for each customer i want to track their spending and get a total for each customer. i want this to show inside the record for the individual customer but when i add payments it creates a new record.

PLEASE HELP!!!

luke

from uk but in malaysia

Welcome to FM Forums, Luke!!

Even without knowing the structure, it should be possible to explain. I will assume you currently have a relationship from Customers to Orders and that the Orders contain a TOTAL field. The calculation I provide will be based upon these names - you will need to adjust the calculation to match your actual file and field names.

In Customers, create a *calculation (result is number) with:

Sum ( Orders::TOTAL )

Place this field on your Customer layout. If this doesn't help you then we will need more information.

* When creating the calculation, select the file and field name from the popup (upper left in the calculation dialog). Double-click to insert the file/field in place of Orders::TOTAL spot.