I am creating a pretty basic CRUD application with Oracle Apex. I simply want to create a hierarchy based on some logic that spans 4 tables all on one page. In our current application which we are trying to convert to Oracle Apex we have a list of nodes that when we click on them we can display their children tables in the main view.
Lets say we have 4 tables, each with Primary Keys that relate to one another. How do I display certain values from these tables on the page all at the same time? I have tried some of the wizards that Apex provides but with no success. I think it will have to be custom PL/SQL logic. The data has to be in a certain order as well.
How can I create a view similar to this?