Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Forms4.5 How to Calculate subtotal while making Data entry.
Your Kind attention please.
I am having a block defination with multiple record display( 5 Records ).
Say for Example EMP table
Columns Such As Ename and Salary.
While adding records to emp table through Forms45 I want
the subtotal of what all Salary is entered.
John 3000
Scott 4000
Total 7000
I have tried writing a key-nxtfld trigger on Item Salary passing a value to global Variable,it calculates the total but when I modify the entered value it again adds the modified value rather than the difference.
How do i go about it.
Which trigger I should write and How ?
Thanks in Advance.
Paggy.
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sat Sep 05 1998 - 04:53:54 CDT
![]() |
![]() |