Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Problem with master-detail in APEX 21.1.5

JeanYves BernierOct 14 2021 — edited Oct 14 2021

Hi ,
In my app I have created a Master Detail with Drill Down by the assistant
So in the master detail page I have 2 regions :
Master is type of Form and detail is Interactive grid
When I choose an item that already have details, these are shown correctly in the IG according to the generated where clause of the IG.
But when I try to add a detail record in the IG the fk column is not generated as the master column.
What I see is that I can't select the property of Master Column
image.pngSo I made another master detail with Stacked.
And with this type of page I am able to insert new detail records
And the Master Column I am able to select the parent column
image.png
Is this a bug or what did I wrong ?
Thank you for your help
Regards
Jean-Yves

Comments

JeanYves Bernier

Any help on that issue ?

JeanYves Bernier

No one to help me ?

Rick-Pick

I'm not sure that a master-detail with a form as master and grid as detail is supported. You might be able to make it work by populating the master column using javascript in a dynamic action, or even by making the master item the default value for the column?

JeanYves Bernier

Hi Rick,
Sorry for the late reply.
The pages were created via the assistant "Create a Page" > "Master Detail" > "Drill Down"
This results of one page with the master table based on an interactive report and a detail page with a form region for the master table and a interactive grid region for the detail table.
So I expect this must be supported no ? But I'm not able to select the Master Region in the Master Detail property of the detail region.

1 - 4

Post Details

Added on Oct 14 2021
4 comments
847 views