This discussion is archived
3 Replies Latest reply: Jan 20, 2013 11:52 PM by HamidHelal RSS

LOV selection in tabular form

shuvro Newbie
Currently Being Moderated
Hi guys,
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.
  • 1. Re: LOV selection in tabular form
    HamidHelal Guru
    Currently Being Moderated
    shuvro wrote:
    Hi guys,
    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.
    hello shuvro,
    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
    SELECT ITEN_NAME
    FROM ITEM_TABLE
    WHERE ITEN_ID NOT IN (SELECT THIS_TABLE_ITEM_ID
                                        FROM THIS TABLE)
    Hope this helps


    Hamid



    If someone's response is helpful or correct, please mark it accordingly.*
  • 2. Re: LOV selection in tabular form
    shuvro Newbie
    Currently Being Moderated
    Many many thanks . Its solved.
  • 3. Re: LOV selection in tabular form
    HamidHelal Guru
    Currently Being Moderated
    Praise be to Almighty Allah (God)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points