Hello.
I am working on a page that contains two sections with forms interacting with the PERSONS and PERSON_EXTRA_DATA tables.
When inserting a new record using the CREATE button, everything works as expected:
A new record is created in the PERSONS table.
A related record is created in the PERSON_EXTRA_DATA table.
The Problem
Issues arise when a record already exists in the PERSONS table, but there is no corresponding record in PERSON_EXTRA_DATA.
When clicking the SAVE button, the appropriate value is sent to the REQUEST page parameter, which tells the Form - Automatic Row Processing (DML) whether to perform an insert or an update.
The update for the form linked to PERSONS works correctly.
However, for the PERSON_EXTRA_DATA form, a new record is not inserted because it attempts to perform an update instead of an insert.
The Question
Is it possible to assign different values to the REQUEST parameter for two different forms so that one performs an insert and the other performs an update?
Or is there a better approach to handle this situation?
I would greatly appreciate any advice.
Environment: Oracle APEX 23.1, Oracle Database 19c.