developer 2000 forms post records

developer 2000 forms post records
Situation:
I want to be able to post the records in the database..as I move to the next record in a block (a detailed or child block). So, I put a trigger on the block in question "when new record instance" as:
if (:System.Record_Status IN ('CHANGED', 'INSERT')) Then

:system.message_level := 5;

 post;
:system.message_level := 0;

end if;

with above trigger, it does post it to the database...but in a weired way:
as the user adds a record and tab to the next record, at this time the previous record should be posted to the database, instead the user has to take a step back and put the cursor back into the previous record to post the previous record into the database... This block does has some of the items that are getting populated in pre_insert and pre_update triggers only...I don't know if that is the issue...

So, is there a way for it to post it to the database in the easy way (i.e. without stepping back into the record).. I have tried changing the trigger where I changed the line: if (:System.Record_Status IN ('CHANGED', 'INSERT')) Then to
if (:System.Record_Status IN ('CHANGED', 'INSERT', 'NEW')) Then

This solved the problem only for the instances..where the block has atleast one record in it as you open the form, but it started new issues like..users couldn't delete records out of the block...or if the block didn't have any record in it when you open the form..and you step into it...it will lock the system

help help help

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 17 2001 - 18:25:04 CST