Validation based on a max value for a sum in a portal

[Tpk309]

Hello,

I have a portal with a field containing a duration (time).

I would like to make a sum of this field for each entry of this portal, and forbid the user to enter duractions so that the total of the portal would be more thah 24 hours.

Is this possible ? And how do you suggest to make it ?

The problems I encounter are

- The summary field does not automatically update, I need to change record and get back, or close the database or so.

- In IWP, the updating of the summmary field seems ok, but the validation on the duration field seems to happen BEFORE the update of the field. Which means it doesn't really validate base on the new total but base on the total that was enter before, and in the end it doesn't allow the user to change anything ...

But maybe there is another way ?

Thank you if you can help me. (IWP compatibility is required)

Edited July 29, 2008 by Guest

[Tpk309]

PS Is this a valid syntax for field validation ?

"SumHours ≤ 86400"

(SumHours is a Summary Field)