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?