Version: APEX 20.1
I have a list of values based on a SQL Query in the Shared Components List of Values :
SELECT CUST_NAME, CUST_NO, CITY, STATE
FROM CUSTOMER_TBL
ORDER BY 1
Under "Column Mapping" I have the "Return" set to CUST_NO. The "Display" is set to CUST_NAME
I applied this shared lov on a Popup LOV page item. When a value is selected from the LOV, the value of CUST_NO appears in the field not the value of CUST_NAME.
How do I get the CUST_NAME to display in the page item instead of the CUST_NO?