FORMS4.5: Editing two records at the same time

[Quoted] Hi, out there!

This is my (simplified) problem:

I have a block with the following database fields: SomeID (NUMBER), Amount (NUMBER). Initially there is only one record in the table. Sometimes the user presses a button and adds a record at the end of the list. The SomeID field is initialized to a unique value and the Amount field is set to 0. Then the user navigates to the Amount field and enters a value. When he leaves this field, the new value must be subtracted from the Amount field in the record above, so that the sum of all Amount fields remains constant.

And the problem is: How can I reach the previous record? I want to use the POST_CHANGE trigger, but I can't use a previous_record because it is a restricted procedure.

Any ideas?

-hans- Received on Mon Jul 28 1997 - 00:00:00 CEST