Sum of Amounts from multiple records

[bjames]

I will try to explain this as best as i can. I have two layouts, Customers and orders. Each customer is tagged with a unique ID# which is also used for there orders made on the Orders layout. What i need to do is have a field that shows the customers sum of all orders on the customer layout. Now each order placed is a new record on the order layout. I have figured out how to put a portal on my customer layout that shows all of that customers orders but cant for the life of me figuer out how to do this. Hope someone can help

[Søren Dyhr]

Study how this function:

http://www.filemaker.com/help/Functions%20Ref9.html

...is used in this template:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000717

...which BTW is almost canonized approach to everything ordering, unless special esoteric virtues are sought for!

--sd