Re: column total in forms

Hi

You didn't tell your forms version, but if you use 6i (or 5, I think) you can use a computed control item. See the "calculation" group of item properties. You can create a summary computed item that automatically SUMs the percentages, an in the pre-commit trigger you can check if it is = 100...

hth

"Pieter J.D. Huiberts" <phuiberts-REMOVE_at_ivw.com> wrote in message news:<3D279D7F.90504_at_ivw.com>...
> Hello,
> I am developing a time distribution form in forms (dev/2000). The user
> gets pressented its projects in rows, and can than assign how much of
> his time (%) he spend on a project each month. Before committing this
> info to the db, I would like to validate that the time totals to 100%.
> How can I total these text_items before committing them into the db?
>
> Is it possible to do something like total := row1 + row2 + row3, where
> the cursor loops from the records?
>
> example:
> The user sees this form and only fills out % of his time spend.
> Projects Time (%)
> Project 1 33
> Project 2 33
> Project 3 33
> Total 99%
>
> Thanks a bunch,
> Piet
Received on Sun Jul 07 2002 - 12:06:19 CDT