Calculationg totals for a invoice with line items

[mediarare]

So, I a have a solution, with an invoice table, and a line item table. I want to total some values in the line item table and show them in the invoice table.

I've tried using a calculation field in the invoice table that calculates the fields from the relationship between invoice and line item as described in the help file, but it isn't working for me.

Some things I've tried is to make sure the evaluation context is correct, to uncheck the do not evaluate if all referanced fields are empty and the do not replace existing value for field.

Attached is a file i quickly rebuilt with just the invoice and line item tables with the same configureation, but the subtotals do not work.

Is there something i'm missing? I havn't been working in filmaker dev 7 for very long, though i've been using filemaker since version 4.

Thanks for any insight provided!

test.zip

[-Queue-]

Change your auto-enter number calculation fields to true calculation fields.

[mediarare]

There we go, what was I thinking.

Thanks so much!