Hi all,

Another FM6 question for everyone.

I need to get a count of a subset of related records.. that is only
count related records that meet certain criteria.

In my case, I want to count all records except those that have a
particular code in one of the columns.

Any ideas?

Thanks
Andy

You may create a new field 'Token' = Case( meeting criteria, "X", "")
Then CountRecords = Count(YrRelationship::Token)
There are other ways.
Remi-Noel

"Andy" <ajohnstone (AT) capcitypress (DOT) com> a écrit ...