Hi,

I'm struggling with a data filtering problem.

In Subform I have two fields of type Lookup (multiselect). 
First field. Ingredient, has links to the secound filed Function.
I want to set the filter to in secound field Function. ID equals input.Ingridient, and it works fine. 

The problem comes, if the Ingredients field does not have a link to Function. In this case, I would to see all the values from the field Function to be displayed.

 Is it possible to get such an effect with the help of the second condition OR, AND ?