Hey,
i want to create a process which loads data into a form.
It should sets the display value of a Textfield and sets the hidden value / return value of the textfield.
The display value should be the name and the hidden value the id. Same as a POPUP LOV.
select PROJEKT_TYP_NAME display_value, PROJEKT_TYP_ID return_value
from PROJEKT_TYP
order by 1
I tried the function apex_item.hidden but thats not the right function.
Is there a function which sets the hidden/return value?
BEGIN
SELECT PROJEKT_TYP_NAME, PROJEKT_TYP_ID INTO :P28_ PROJEKT_TYP_NAME, <HIDDEN VALUE OF :P28_ PROJEKT_TYP_NAME> FROM PROJEKT_TYP WHERE No=2;
END;
:P28_ PROJEKT_TYP_NAME is a POPUP LOV. I need this for a Modify Form.