APEX

Hello Gurus,

I have a Cascading Select List in a Tabular Form made with APEX_ITEM.

My Tabular Form is like this: Col1[select list], Col2[select list], Col3, col4 .

Now :- I would like Col2 to be made as a TEXT BOX as opposed to SELECT LIST. But this TEXT BOX should still be populated "On Change" of Col1 and the TEXTBOX should be editable.

I saw another function called: TEXT_FROM_LOV_QUERY but I can not set the item_id [to use in HTML HEAD Java Script Function & Application Process] as the signature of the function does not support.

APEX_ITEM.TEXT_FROM_LOV_QUERY (
    p_value       IN    VARCHAR2 DEFAULT NULL,
    p_query       IN    VARCHAR2,
    p_null_text   IN    VARCHAR2 DEFAULT '%')
    RETURN VARCHAR2;

Please point me to any relevant examples.

Appreciate any help in this regard. Please let me know if I could not explain my problem well.