This content has been marked as final. Show 3 replies
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.
Issue Commit_form; in when New-Record_instance trigger of the tablur form. Then in your record group of the LOV use NOT in like bellow example
Hope this helps
SELECT ITEN_NAME FROM ITEM_TABLE WHERE ITEN_ID NOT IN (SELECT THIS_TABLE_ITEM_ID FROM THIS TABLE)
If someone's response is helpful or correct, please mark it accordingly.*
Many many thanks . Its solved.
Praise be to Almighty Allah (God)