Home » Developer & Programmer » Forms » Summary Field Validation! (Forms 6i & Database 9.2)
Summary Field Validation! [message #391743] Fri, 13 March 2009 05:34 Go to next message
Messages: 1
Registered: March 2009
Location: Indonesia
Junior Member
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 Go to previous message
Messages: 36
Registered: October 2006
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.

Previous Topic: how to count the no of rows in a block before inserting
Next Topic: Mandatory Field problem
Goto Forum:

Current Time: Mon Oct 24 21:02:02 CDT 2016

Total time taken to generate the page: 0.15658 seconds