Hello, i have just changed a layout from repeating fields to a join table with a portal, all works well as you can see by the demo.it adds the line items up. or advise me if there is a better way.

but i want to "sum" the total of all records, i have tried calc fields summarys but nothing works for me, and i cannot work it out. can some one please take a look and tell me where i am going wrong thank you.

Robert

expenses.fp7.zip

If you create a new Cartesian 'X' relationship then you can reference the Summary field or sum it for the total of all the child records.

I'm fully with John in his suggestions, further more have I made two mods of your file to show the various benefits of having related real summary fields and the use of aggregate functions.

The problem you discover with related summaries is that they won't freshen when ever you alter something in a portalline, and in order to give the right figures must a button issue a:

http://www.filemaker.com/help/ScriptsRef-269.html

I write this to pursuade you to use the ...fresh version of the templates attached. I have allowed my self to strain considerably in your fields, as well as removing the grand summary area.

--sd

expensesFresh.zip

expensesHang.zip

How about something simple?

expenses2.fp7.zip

Yeah at bit of both, should have covered that as well!

--sd

Wow thanks for the help and showing me different ways to achieve the same result. at the moment i am using "comments" version as it it so easy to install, but i would like to use Sørens method so i will try this when i can work this out and i understand the logic. again thank you, Søren, Comment and Mr Vodka

RT