Updating the total of a field from individual entries

[rollandpate]

Part of our application tracks competition points for each individual. I have a table with the person and points per competition. This table will have multiple entries for each person with the points they received for that competition.

I would like to keep a running total of points in the person's individual record to be used for a variety of functions other than simply reporting the totals in a report.

So, any suggestions on how I can update the total number of points for a person each time that person is entered into the details table?

Thanks

[ShWolf]

Hi,

Looks like it could be done in JS only.

[rollandpate]

Any chance someone has an example of how this could be done in JS?

[PatrickCuezze]

+1 and Bump.  I'm looking to create a type of loyalty program where individual records add "points" to a persons "account".  I'd like to be able to generate a report of their total points.  What's the easiest way to do this?  Thoughts would be appreciated for a noob.  Thanks in advance.