Hello, I'm having a small problem using collections.
Details:
Page 1: Interactive report: list of transactions with a link to view the details of a transaction. Page 2
Page 2: Page for creating and modifying transactions with a "Next" button to go to page 2.
This page contains an interactive grid based on a collection called 'COL_ACCES' to add access rights.
The addition is done directly in the collection; no records are added to the database.
The recording will take place in the next step.
If access rights were assigned during creation, then I need to populate the 'COL_ACCES' collection with this data.
Clicking the "Next" button takes me to page 3.
Page 3: Summary page contains a "Previous" button to return to page 2 and make changes, and a "Save" button to save the data (using PL/SQL packages).
Problem: When I'm editing a transaction and I add access points, then go to the next page and then back, I either lose the added data or duplicate existing data from the database. Please help!