| Sum of Summrized Item [message #403393] |
Fri, 15 May 2009 05:45  |
snsiddiqui
Messages: 172
Registered: December 2008
|
Senior Member |
|
|
Dear All
Could I get sum of any summarized item and will they reside in a same block or different?
Basically, I have three different blocks in a form
1- master
2- detail
3- sub-detail
detail and sub-detail blocks contains two separate summarized item and I want to check these two items at the time of record saving, if these items are equal then save otherwise raise error message.
Please give me your great suggestions.
|
|
|
|
|
|
| Re: Sum of Summrized Item [message #403656 is a reply to message #403438] |
Sun, 17 May 2009 23:07  |
snsiddiqui
Messages: 172
Registered: December 2008
|
Senior Member |
|
|
Thanks for the reply but as I mentioned in my first post about three blocks
1) Master
2) Detail
3) Sub-Detail
so your given suggestion isn't enough to check values because DETAIL block summrized item contains all records total but the SUB-DETAIL block contains only current record total.
I want to stop user or I don't want to save records, if these totals are not equal.
[Updated on: Mon, 18 May 2009 00:52] Report message to a moderator |
|
|
|
| Re: Sum of Summrized Item [message #404502 is a reply to message #403656] |
Fri, 22 May 2009 00:45 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
I suggest that you change your design so that the sum on the sub-detail item populates the detail item automatically. That way the user does not have to enter the database twice.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
