I would like to create an interactive grid in APEX 5.1 to replace this Oracle Form:
The form is based on a Waitlist table, which contains the columns that are circled above.
The Waitlist table also contains a non-displayed Person Key field.
I am looking for a way to replicate the following behavior:
- When existing Waitlist records are displayed, the page should display the ID and Name from the Person table, using the Person Key.
- When a new record is created, the page should allow the user to enter the ID, then retrieve and populate the Person Key field and Name fields.
In Oracle Forms, these tasks are accomplished with a POST-QUERY and POST-CHANGE trigger, respectively.
I know how to create similar functionality in APEX using a Form with a Report.
I was hoping to use an Interactive Grid, however, so the user has the ability to easily click in the Select box of multiple records to perform other functions on those records (i.e. e-mailing those students, admitting them, etc.)
I'm trying to accomplish #1 using a "GET_ID_AND_NAME" Dynamic Action on the Person Key field. I've tried an After Refresh event and a Change event. Is that the wrong approach? I'm wondering if I'm stuck in Oracle Forms thinking (relating Dynamic Actions to Triggers) and there is another way I should be retrieving these fields for existing records, such as using a Process, Computation, or Validation?
There are over 300,000 records in the Person table, so an LOV is, unfortunately out of the question.
Thanks