The "client table main table 2::LIVE CLIENT" field is currently set to have many project ID numbers in as I often have to do 3 or 4 at the same time.
what separates one ID number from another in the field when you have more than one ID number in it?
Thanks, that's got me thinking about ways to sort this out.
The field is an edit field box field and the ID numbers are separated by a new line/carriage return.
So the field looks like this:
With all these numbers being project ID numbers.
Then you can replace your use of Patterncount with the FIlterValues function. This will treat each return separated value as a discrete value.
Not IsEmpty ( FilterValues ( client table main table 2::LIVE CLIENT ; client table main table::LIVE PROJECT) )
But a return separated list like this can also be used as a match field in a relationship to match to any of the listed values or you can replace it with a join table to get a true many to many relationship so you also have alternative approaches that you can consider.
Perfect, I made the changes and there is no pollution in my portal from other Project ID number that shouldn't be there.