In a former blog post JDeveloper 11.1.2.1: Cascading Tables I showed how to cascade two tables. Lately I saw a couple of request on the OTN JDeveloper & ADF forum on how to do this with multiple tables.
This blog extends the sample given in the old post to show how to add another cascading table. For this we need to add an other entity view object pair to the project, build the needed association and view links to the existing entity and view object, change the data model of the application module and finally change the UI to show the new cascadeing table.
Lets start to add the new JobHistory entity and JobHistoryView view object. For this you can open the ‘New Business Components from Tables…’ wizzard on the existing business components node in the application
Add new Business Objects
Follow the wizard…
Select new Table
Select new ViewObject
Don't add new ApplicationModule
The result of this operation should look like this:
Result of the Wizard
Now that we only added one table, the framework did not pick up the foreign key relationship between the Employees and the JobHistory entities. We have to build the needed association and view link ourself…
Build New Association
... Name it ...
... Select the Attributes ...
... Remove the not needed Navigation from JobHistory to Employee ...
Step to the end of the wizard and click ‘Finish’, save your work. Next we create the ViewLink based on just created EmpJhistFkAssoc…
Create ViewLink ...
... Name it ...
... Select the EmpJhistFkAssoc for both ViewObjects ...
At this point you can click ‘Finish’ as no other change need to be made in this wizard. After this we add the new JobHistoryView to the application modules data model as a dependent ViewObject (on EmployeesView). Open the BCTAppModule application module and select the ‘Data Model’ node
Open BCTAppModule and select the ViewObjects...
… and hit the shuttle arrow to put the JobHistoryView under the EomployeesView3…
Final Data Model
Save your work and compile the model project. Next we change the UI to show the job history for the selected employee. If you open and refresh the data model of the ViewController project you see the new JobHistory1 under the EmployeesView3…
Data Model in ViewController...
Now we open the existing Dep.jsff page fragment to add an other af:panelCollection under the existing two
...add af:panelCollection ...
drop the JobHistoryView1 from the data control onto the new af:panelCollection as ‘Read-Only Table’…
... Drop JobHistoryView1 into panelCollection as Read-Only Table ...
... Setup Table as 'Single Selection' and allow Sorting ...
Finally we need to setup the partial triggers for the JobHistroy table so that the table reacts of changes of the departments and employees table…
Setup Partial Triggers...
... React on Department and Employee changes...
Save your work and run the application. That should open the Page with three cascading tables visible. If we change the department to e.g. ‘Sales’ and select the employee with the id 176 we should see
Final Cascading Table Application
You can download the sample workspace, build with JDev 11.1.2.1.0 and depending on hte HR db schema, from here: BlogCascadingTableV2.zip
Please rename the file to ‘.zip’ after downloading it!
JDev & ADF Goodies 
Very interesting info!Perfect just what I was searching for!
God bless you !
Thank you, was useful for me.
Regards