APEX

Dear All,

I am getting back into using APEX again after a few months away from it. I have a dropdown list (LOV) based on a query on PAGE_3, thats working fine.

I need to put the value of the dropdown list into an item on PAGE_0 so I can use it again when I refresh a report on PAGE_3. I have a button 'SUBMIT' and under Optional URL direct I set target is a 'page in application' page 3, set these items 'P0_HIDDEN' with these values '&P3_ANSWER.'

But the issue I'm having is that the P0_HIDDEN item is not being populated when i click a button, but if I hard code the value of 'with these items' the value in P0_HIDDEN is populated. I'm really stuggling with this.

Also, is there any way to do this and run a process at the same time, e.g. to insert rows into a table. I can only seem to get either a this non functioning refresh or an insert to work but not both at the same time.

This is not easy to explain but I've tried my best.

Many thanks is advance.

Niels