Hi
Apologies that this appears simply question, but I cannot find solution post or determine what I am doing wrong.
1. There is text item called P7_PROPERTY_TOWN_NAME. Nothing special here.
2. There is second item called P7_PROPERTY_STATE. I would like this to display State (Australia) based on Town (P7_PROPERTY_TOWN_NAME). This is Select List with Cascading LOV Parent Item set to P7_PROPERTY_TOWN_NAME.
The List Of Value Definition references P7_PROPERTY_TOWN_NAME as below
select distinct pc.state disp, pc.state ret
from post_code pc
where pc.town_name = :P7_PROPERTY_TOWN_NAME
order by pc.state
Problem is that P7_PROPERTY_STATE select list does not update when enter valid Town and leave field.
We are on APEX 4.2. Documentation says Cascading LOV can be based on text item. Quote from Patrick Wolf (Oracle) blog below. If I make P7_PROPERTY_TOWN_NAME some kind of LOV such as Select List or Popup LOV and select Town from list then values for P7_PROPERTY_STATE do change, but I wish for text entry of Town.
Important to mention here is that the parent field doesn’t have to be a select list, it can be a simple text field, date picker, … as well. Every DOM element which fires a change event will work as parent.
Not sure what I am doing wrong. Advice appreciated.
Thanks