I have created a report (browse) on a table that contains records that indicate which manuals a person is authorized to edit. The primary key is named manual_id. When the user selects a certain manual to edit, I need to set an application item equal to the manual_id of the record s/he selected and that application item will be used in another report (browser) to restrict access to only the entries for the selected manual in a second table that contains editing entries for all 100 manuals being tracked..
I created an application item named V_BOOK_ID and have tried half a dozen ways to populate it with a Computation set to fire after the page submit but have not had any success.
I am a novice with Application Express and am at a loss how to set V_BOOK_ID to P*_BOOK_ID of the selected record.
Have a column in your report be a link. Inside that link define
Target: Page in this application
Page: same page you're at or new page you want to go
Item 1: V_BOOK_ID Value: #BOOK_ID#
This simply technique will set the value of a column in your report called BOOK_ID to V_BOOK_ID. You can easily use Pn_BOOK_ID too even if the page for Pn_BOOK_ID is different from the page you want to go to.
I would recommend you go thorugh the "2 Day Developer Guide" (Oracle Application Express - Documentation</title><meta name="Title" content="Oracle Application…) or get an APEX book.
Hope this helps