4 Replies Latest reply: Nov 24, 2013 5:51 AM by O.Developer RSS

    How to update the LOV without commit

    basavarajpatil

      Hi all,

       

      I have a form where in a user is allowed to enter/delete the records to a table using buttons(ADD/DELETE) and SAVE AT ONCE (commit_form). I have a lov as one of the fields which fetches the data from a different table.

       

      My requirement is mentioned as below.

      I have entered a record by clicking the ADD button . this record has the column MIS(selected from the LOV). lets say the value is 1000.

      when i click the ADD button again, to enter the second record, the LOV MUST NOT SHOW the value 1000.

       

       

      i tried adding the parameter to hold the previous values and using this parameter in the RG query but it is not accepting.

      Please help

       

      Regards,

      Basavaraj