APEX

I am trying to redirect to a second page via a button but at the same time populate a item on the second page from a function that returns a sequence.

I tried all sort of methods, adding page processing, adding dynamic actions, adding branching and cannot get this to work.

The button must create a new record on the second page, but populate unique key at the same time. Because redirecting does not Submit, adding page processing AFTER submit does not work. I get that, but the following also will not work and I don' know why

Create dummy field on page 1
Create page processing that populates the field via PL/SQL "On Submit"
Create Region button that simply Submits page
Create branch that on submit redirects to second page and moves the value from the dummy field on first page to the field on the seocnd page.

I am new to Application Express and love trying to figure issues out myself but am at a loss with something that should be so simple. Any help would be appreciated.

Stewart