Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Generate extra record when create a new record in secondary form

KittyMar 26 2012 — edited Mar 29 2012
I have been troubshooting this for a logn time:

I have exemption form ties to exemption table. because there are two many info on exemption form, I create a second form called exemption (2) form and ties to exemption(2) table. Then, I create a "Go to exemption(2) form" button from the first form and it will redirect the user to the second form once they click it.

Once the users complete the second form entry, and click the Create(which is the save record) button, it not only creates a new record in exemption (2) table but also create an extral record in the first exemption table.

I used the exemption sequence to genertate the id so for example,

Exemption (1) has 3 records so far, but after the user add the record in the second form, Exemption (1) has 4 records.

How do I make the first form and the second form consistent in the ID?

Thanks so much in advance!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 26 2012
Added on Mar 26 2012
14 comments
243 views