This content has been marked as final. Show 4 replies
define record group query like as..
select DECODE(:BLOCK3.TEXT_ITEM4,1,EMPL_CODE,EMPL_NAME) EMPL from FIFAPPS.FS_MST_EMPLOYEES
In the Record Group that populates the LOV, you can put placeholders that points to the Forms items.
Amit1cs wrote:Hello Amit,
I got a required to show LOV based on some value in other column. Let me explain ... suppose in column A has value is A1 then column B should show A11, A12 , A13 and if Column A has value C then cloumn B should show C11, C12 ... etc. The LOV will be static with some pre defined values. So all the LOVs will be defined in forms. We just need to show based on value in column A .
So far i understand, you can create multiple record group for a single LOV. before display the lov just change or assign the appropriate record group. You may use pre-text-item trigger at column B and set the record group to your LOV.
Hope this helps
This is resolved. Thanks.