I am an novice user with a Contacts table listing mother's name, and a Birth table listing one record for each of her children. Contacts is related Contacts::ContactID = Birth::ContactID to a second occurrence of the Birth table. I have the following calculated field in the Contacts table, counting how many cesareans she's had from the Birth::BirthOutcome field:
PatternCount (Birth 2::Birth outcome ; "CS") + PatternCount (Birth 2::Birth outcome ; "ERCS") + PatternCount (Birth 2::Birth outcome ; "RCS")
It seems to only be counting one, no matter how many births she has in the Birth table with more than one. What am I doing wrong?