Summing a related repeating field into a repeating field

[tpwild]

Hi

I have a table with a repeating field called Days[15]

In a related table I want to create a repeating field called SumDays[15] where each repetition is the sum of the corresonding repetition in Days for all related records

In trying to find a solution to this I have seen a lot of people advising that repeating fields should be avoided if possible. Unfortunately I have an existing database with about 50 scripts that would all have to be re-written if I get rid of the repeating field.

Is it possible to sum a related repeating field into a repeating field?

Thanks

Tom

[mr_vodka]

Did you try using a summary field with the option to sum them up individually by each rep? Also I would definitely agree with the advisement. This should be related records in its own table.