ok, so none of this still solve my case. I will go through the problem once again.
I have Items. Items have multiple fields, including the field Containers, which is a list of Containers. Every time I create an item I say the values for all the fields, and multiple values for the containers.
But before creating a new Item, I need to know if an Item like that already exists. So I test to find any Item that match those fields. I do a “Search for” the type Item, and test all the fields using “=”. Straight forward. But in the “Search for”, when the field is a list, the only option that appears to test is: contains, doesn’t contain, is empty, is not empty.
First choice in mind is to see “contains”. But with this option I can only test if a certain WHOLE list of containers appears in the a list of containers of any of the Items in the database. But that’s not what I want.
As a item can have any list of container, I need to need if at least 1 container of the item I’m trying to create intersects in the list of containers of any other item. But intersect option DOESN"T exist when we are inside a “search for”.
Thanks for the SQL prompt, but I know the SQL commands. That’s not the problem. the problem is how to use “Intersect” or anything else more than just the 4 options (contains, doesn’t contain, is empty, is not empty. )