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