Sum Function

[matt d]

Hi, ive been reading though the forums and cannot find the asnswer to my question. Anyway, I have two tables. One is ' [color:"blue"] Invoice ' and the otehr is ' [color:"blue"] Line_Items .' The [color:"blue"] Invoice table has a value of [color:"red"] id that [color:"blue"] Line_Items is related to.

Now, here is my problem. I have a layout that is owned by [color:"blue"] Invoice and it has a portal to enter in the invoice lien items. In the [color:"blue"] Invoice table i have a field called [color:"purple"] total . That field has a automatic calculation of ' [color:"#666666"] Sum ( [color:"blue"] Line_Items::Amount ) . This calulation only works at record create time for [color:"blue"] Invoices . How do I make it re-calculate each time a line item is added to [color:"blue"] Line_Items ?

Thank you for your help!

-Matt

[-Queue-]

Change your 'calculation', which is actually an auto-enter calculation in a number field, to a true calculation field that will be unstored.

[matt d]

Duh! I use that all the time, I wonder why I was so stumped!!! Thank you so much!