Hi,
I have an interactive report with a column link that leads to a form to make an update to that single record.
The user would like a "Next" and "Previous" button in this single record page to move from record to record without returning to the Interactive Report.
Any ideas on how I can do this? Is there a way to pass "Previous Record" and "Next Record" for the Previous and Next buttons?
Let's say the single record page is is page 5. I am passing the unique ID from the Interactive Report to an item called P5_ID on the single record page (page 5).
I have two buttons on this page called P5_PREV and P5_NEXT.
I was thinking of having two hidden fields that would contain the IDs for the previous and next records (compared to the current ID in P5_ID). For example: P5_PREV_ID and P5_NEXT_ID.
Is there a way to do this? What would the SQL look like for P5_PREV_ID, for example?
Thank you!