Ive select list item with lov(select ename d, empno from emp) and other fields are based on the selected empno from this SELECT LIST item which triggers on DA CHANGE all is working correct,
but the problem is showing/displaying the LOCATION in the POPUP LOV when the Select list item changes,
the POPUP LOV has lov(select LOCATION_ID, STREET_ADDRESS || POSTAL_CODE CITY || STATE_PROVINCE as "location" from LOCATIONS)
also in the location table ive FK for empno so i can link the tables,
so why isnt the popup lov display selected emp information?
thank you in advance.