I'm trying to enter this field validation for the field Funding Source_CountyOf field using this:
PatternCount (Funding Source ; "County of" > 0 ) and FundingSource_CountyOf = $Null
When the funding source contains the value "County of" (there can be multiple values), the other field FundingSource_CountyOf cannot be empty. When the two parts of this statement each result in 1 (i.e. true) when analyzed separately in the Data Viewer, together they equal zero (false).
How can this be?