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!

How To Filter A Drop Down Based On Another (Changing) Drop Down?

Alex P 7939892Oct 17 2018 — edited Oct 23 2018

hi

I have an apex form where I have a "LOCATION CODE" field that is editable (as a drop down).

Then, I also have another field "GROUP NAME" that is editable (as a drop down).

I have a lookup table for "GROUP NAME" that has "LOCATION CODE" as the first part of the key.

I want the GROUP NAME field lookup to populate with choices based on the LOCATION CODE field.

I can easily do that on the page with an LOV that references the LOCATION CODE field...provided that value doesn't change.

--> The trick is: I need to have the GROUP NAME choices update if/when they change the location code field on the page. This is "more" dynamic.

How do I do this?

This post has been answered by PMON on Oct 17 2018
Jump to Answer
Comments
Post Details
Added on Oct 17 2018
5 comments
1,147 views