| Summary Field Validation! [message #391743] |
Fri, 13 March 2009 05:34  |
Danil
Messages: 1
Registered: March 2009
Location: Indonesia
|
Junior Member |
|
|
Hi,
I've a block having a number field(base table item with multiple record displayed) & on the same block i'm having a summary field TOTAL(non base table item) which displays above base table field's total sum.
Actually i want to validate this TOTAL field to be exact 100.
i've written validate trigger on TOTAL but it seems to be ignored.
Also created NEW/Item/Form/Record instance trigger but in vain.
anybody have idea how do i validate this field(base table item with multiple record)?
Thanks in Advance!
[Updated on: Fri, 13 March 2009 05:43] Report message to a moderator |
|
|
|
| Re: Summary Field Validation! [message #392212 is a reply to message #391743] |
Tue, 17 March 2009 01:08  |
h_jitendras
Messages: 36
Registered: October 2006
|
Member |
|
|
hi,
what you can do is this:
select the item to be of type sum in the property palette of the item.for the data block,set "Pre-compute summary" to ON and then write the trigger you want for the total..this should work.
thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
