Adding integers in different records...

[MikeForest]

I am trying to create a db with a running total.

I have a field in each record that holds a number representing a persons percentage of involvement. I have a script that raises that value by .5%.

What I would like is to have a field displaying a running total of how much of tht total percent is left. (If Tom gets 25 and Liz gets 20, there should be 55 left.) How do I add fields in differnt records togther and keep a running total that I can subtract from 100 and have a remaining percentage displayed in a field that would be the same no matter what record I am looking at?

[Razumovsky]

This sounds like it could be done with a calc field and relationship.

create a relationship of all to all

create calc field c_RemainingPercentage:

100- sum(all::n_Percentage)

where n_Percentage is your number field where the individuals percentage would be entered.

HTH

-Raz