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!

Is it possible to have cascading LOV but on two different IG?

1632411Jul 14 2025

Bit of context:-

The data in my table is in the form of heirarchy

Area-1  
    ->subArea-1  
    ->subArea-2  
    ->subArea-3  
    ->subArea-4  
Area-2  
    ->subArea-1  
    ->subArea-2  
    ->subArea-3  
    ->subArea-4

I have a Master-Detail Interactive Grid (IG) used to input Area and SubArea data.
-The Master IG is used to input the Area, and I’m using a List of Values (LOV) for selecting area_name.
-The Detail IG is used to input SubArea, and I’m using an LOV for selection there as well.

Can I implement a cascading LOV, such that after selecting an Area, only SubAreas with the corresponding parent_area_id (matching the selected Area in the Master IG) appear in the Detail LOV?

Thanks in advance

Added on Jul 14 2025

#apex-cascading-lov, #apex-discussions

2 comments

55 views