Including multiple clients in a find from one checkbox global field
I have a find layout that uses global fields to create search criteria. I want to be able to reduce the records to the small number of clients selected in a checkbox set. The problem is that if you create a variable with the list of the clients for a search of the client field no records will be found because they only contain one of the clients, not all of them.
Currently there are 22 clients and this will continue to grow so I need a way of finding all records that relate to any one of the clients in the check box list without having to create a long list of variables for many specify find requests.
Any thoughts? FMP13