APEX

Hello,
I have a report that uses 3 tables to get the desired information. When I create my report, I'm displaying all of the action items...from all boards/meetings...for a particular department. I have added a link column that branches to a detail page where the user can update or delete the action item information. On the detail page I need next and previous buttons that scroll through the list of records on the first page (report page) which is a list of all action items for a department. So the user selects the department on the report page, the query where clause selects all of the boards/meetings for that department and finds all of the open action items for each board/meeting. I need the next/previous buttons to scroll through all of the action items for the department, not one board/meeting. I used the master detail form to build the report/detail page which gives the ability to add next/previous buttons to the detail page, but the buttons scroll through the list of action items for one board/meeting. I have to go back to the report page, select an action item from another board/meeting, then I can scroll through the action items for that board/meeting.

I don't see anywhere on the detail page next/previous page process where I can use fields from other tables...just one table is allowed. I'm thinking I'll need to create my own page process? Does anyone know how to go about doing this?

Thank you,
Tammy