Look up for a particular option.

Hello Everyone,

I have created an option field ‘Item Type’ in ‘Item Journal Line’ table with few options like: Paper Roll, Ink, Plate, Chemical. Then I have taken this field in ‘Item Journal’ page.

Now from ‘Item Journal’ page if I select an ‘Item Type’ = Paper Roll then the look up page of ‘Item No.’ will only shows those values whose ‘Item Type’ will only be ‘Paper Roll’. How could I do this? I have no clues!

Thank You in advance.

use Item as Record Variable

iItem.Setfilter(Item.“Item Type”,’%1 | %2 |…,‘Paper’…);

As per your latest post I think it is resolved by yourself