Getting NEXTVAL just prior to a COMMIT

We are looking for suggestions on how to assign an ID number based on the NEXTVAL of a sequence generator, after all the other fields of the table have been filled in.

The data will be entered through forms 4.5, I know that we can control the navigation, thus enabling us to enter the data for the other fields befor getting the nextval, but what trigger, or combo of triggers, would I use to perform this feat of magic. I can set it up so that I start with a when_button_pressed trigger, but then what?

If anyone could point us in the right direction, Well thanks in advance, and many blessing to you and yours.

Craig Harper Received on Sat Sep 09 1995 - 00:00:00 CEST