Re: Immediate Update of Running total
Date: 22 Apr 94 07:19:52 EST
Message-ID: <little_jeffrey_s-220494072227_at_jarhead.d52.lilly.com>
In article <2p60ul$70e_at_hobbes.cc.uga.edu>, brian_at_natas () wrote:
> hi,
> I have a quick question that maybe someone could answer.
> I have a master/detail, two block situation in FORMS30
> on oracle version 6 where I need to update a total field
> in the master block everytime the corresponding detail
> total is entered or updated. This is not
> difficult, I know, but I have not had any success
> with it so far. Any replies or examples would be
> much appreciated.
If I understand your situation correctly, it seems that easiest thing to do is to define an ON-VALIDATE-FIELD trigger for your total field in the detail block which updates the total field in the master block. Whenever you change the (or enter) the value in the detail field and then navigate out of the field, this trigger will fire and update your master field.
Hope this helps!
-- Jeffrey S. Little Eli Lilly & Co. little_jeffrey_s_at_lilly.com I work in Systems, not in Corporate Communications. Therefore, the opinions I present are mine, not Eli Lilly's. "My Karma ran over my Dogma." --AnonymousReceived on Fri Apr 22 1994 - 14:19:52 CEST