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