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!

Interactive Grid - Cascade Delete not working

user1.0Nov 28 2022

Using Apex 19.2.0.00.18
I have a page with master/detail interactive grids.
I have the columns in the detail grid setup to align with the columns in the master grid. When I select a record from the master grid, the detail grid is refreshed with the corresponding data. So it seems to be linked correctly.
I've added an action column to the Master grid so the user can delete the row and presumably the corresponding row(s) in the Detail grid. However, it doesn't work. If I select Delete from the Actions Menu on the Master row only the Master record is flagged to be deleted. Then when I click Save, I get an error because there are "children" in the Detail grid (table).
How do I get these setup to cascade delete using the Actions Menu delete option in the Master grid?

This post has been answered by user1.0 on Nov 30 2022
Jump to Answer
Comments
Post Details
Added on Nov 28 2022
1 comment
532 views