I am using Application Express 4.2.1.00.08
here's what I'd like to do
- generate a standard master/detail via the wizard
- enter the generated M/D page with no master PK
- use the create button to enter a master record *but*
- stay on the same page, with a detail section now available
- add detail rows
- save all
by default the CREATE request redirects to page 0 (weird default)
if I correct that to post to self, the fields are blanked after the master record creation (which occurs as I can verify).
I do not understand this as the "reset page" process should only occur when leaving through the DELETE button.
I am puzzled.
Entering the page with the PK of an existing master works as expected,
It just does not seem to work when trying to use the page to create both a master and its details.
I found suggestions to fill the "return PK to field" property, but then I cannot even insert the master recors
(I am getting an ORA-1403)