Help! - Need to add a SUM field

[ekz]

Hey all.. experienced SQL/Web Dev here, with about 48 hours of FM experience

Needless to say, I've achieved about 80% of whats needed for my project

(contact management system , but have this issue:

I need to create a field in one of my Contact layouts that reflects the total

of all that contact's donations; basically a sum of related fields in the

donations table. I found out how to do calculated fields, and use SUM, but i

dont know how to apply it to a situation when there are a dynamic number of

fields/ records to be added.

Any help/direction would truly be appreciated!

-ekz

[MoonShadow]

... and use SUM, but i dont know how to apply it to a situation when there are a dynamic number of fields/ records to be added.

Sum() uses the relationship to summarize and bases its result on all related records belonging to that table occurence (matching that one Contact record) and only to specific fields included in Donations (or Contacts). Thus it must be unstored and will update itself every time a new donation (or Contact) is added.

If you add more fields and want them included in the summarized calculation, you will need to modify the calculation in Field Definitions; or use globals (set via script) to hold your 'variable' fields.