Using APEX 5.1.1. I have two pages one a report (say main page) and other page ( a detail page) which basically opens up as a single record view if the user clicks on any record of the report in the main page.
I use a AFR process to get the details in the (detail page). Now, couple of other functionality I want incorporated into the details page are as follows.
A NEXT and PREVIOUS buttons. This basically allows the user to navigate to the previous record and the next record tied to a primary key.
Please suggest, what's the easiest and cleanest way to achieve this.
Thanks in advance.