Hi everyone,
I'm new to Oracle APEX and would appreciate some guidance on whether my current approach is the best way to achieve what I need.
Scenario:
I have the following tables:
PERSON (p_id)ADDRESS (end_id)PERSONAL_DATA (p_id)ROLES (c_id, p_id)PER_ADDR (pe_id) — a junction table linking PERSON, ADDRESS, and ORGANIZATION (o_id)
What I’ve done:
- I created an Interactive Report listing all
PERSON records.
- When a user clicks a row, it navigates to Page 2, passing
P_ID into a page item P2_P_ID using "Link to Custom Target".
On Page 2, I have three separate forms:
- PERSONAL_DATA — linked to the
PERSONAL_DATA table
- ROLES — linked to the
ROLES table
- ADDRESS — linked to the
ADDRESS table
To populate the forms:
- I use a "Before Header" process to copy
P2_P_ID into form items like P2_PER_ID and P2_PER_ID_1 for the first two forms.
- For the ADDRESS form, I run a process that:
- Queries
PER_ADDR using p_id to get pe_id
- Then queries
ADDRESS to get end_id
- Finally, I copy both values into items used by the ADDRESS form
My Question:
Is there a more native or declarative way in Oracle APEX to populate multiple forms on a page based on a single page item (P2_P_ID)?
Or is it standard practice to use processes to copy values into each form’s items?
Thanks in advance for any advice or best practices!