My source data model is
A list of organisations
An organisation can have many managers
A manager can be responsible for many departments
As my source for the data is coming from our ERP system (EBusiness Suite) each query is a little more complicated. Therefore I have a separate query for each.
On my form I have 3 LOV's (Select One Choice) ... One for each query. The list of managers is dependent on the organisation. The list of departments is dependent on the organisation and the manager.
What would be the best way to achieve this?
At the moment I am considering a Read Only VO for each query which can then be exposed through my application module. However how do I then bind the value(s) from the preceding LOV's which need to be passed into the next query.
Any examples always appreciated.
JDev version 11.1.1.7