Filtering in lookup field from string to stringlist

Filtering in lookup field from string to stringlist

Hi there,

I have a form called Operators and a form called Suppliers and a form called Countries.

Countries contains a list of all countries in the world

An operator will only have one country (Operators.Country)

A supplier will have one or more countries (Suppliers.Operates_in_Countries)

In the supplier form I have a lookup field with a multi checkbox list. In the supplier form I will link all the operators that each supplier is associated with. I would like to filter this multi checkbox so that I only see the Operators that are in the countries I have chosen for the supplier. At the moment I have inserted the following in the Criteria for the lookup field:

Country.contains("input.Operates_in_Countries")

This code is not working. I am still seeing Operators from all countries in my dropdown list. Does anyone know what I am doing wrong?

Thanks,

Anne