Create global temporary table to store the values. Use not in <GTT> command to filter the values from LOV.
First of all create temp. table as follows:
create global temporary table my_tmp (mis number) on commit delete rows;
On forms write the following code in when-validate-item trigger of MIS field:
insert into my_tmp values(:mis);
Modify the existing record group of your LOV and append the following:
.....and mis not in (select mis from my_tmp);
Hope this will help.
Message was edited by: Priyasagi
the thing worked when i put the insert command on the add button rather than a when validate trigger.
sir i can't create temp table and i insert data into the table and then want to disable the valued not eleminated in list.
Good Priyasagi...codes worked.
Another way of doing this is you can 'When -Create New Record Trigger' and pass value :MiS :=0;
This is simple fix