shuvro wrote:hello shuvro,
My form version is Forms [32 Bit] Version 10.1.2.0.2
Ok, now let me brief the problem. I have a tabular form where i used LOV to select different ITEMS. When i select the LOV in the 1st row to select the ITEM............. then my concern is not to show the ITEM in the next row of that LOV which ITEM i have already selected for the 1st. I want to reduce the ITEM on the fly.
If you have any solution for this issue , please share.
Hope this helps
SELECT ITEN_NAME FROM ITEM_TABLE WHERE ITEN_ID NOT IN (SELECT THIS_TABLE_ITEM_ID FROM THIS TABLE)