Lookup_condition

Dear All!

Is it possible to add any condition to the lookup setting? I would like to select used material, if the selected used material lubricant type is “Lubricant grease” in table# used lubricants1.

In the dropdown menu I would like to see only the Aeroshell grease 33 and Mobil Grease SHC 100.

You can add and IF Statament into your SQL.