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

    How to update the LOV without commit


      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