3 Replies Latest reply: Jan 21, 2013 1:52 AM by HamidHelal RSS

    LOV selection in tabular form

    shuvro
      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
          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
            Many many thanks . Its solved.
            • 3. Re: LOV selection in tabular form
              HamidHelal
              Praise be to Almighty Allah (God)