AnsweredAssumed Answered

Counting occurrences in repeating fields

Question asked by WilliamDuncan on Mar 15, 2015
Latest reply on Mar 16, 2015 by philmodjunk

Title

Counting occurrences in repeating fields

Post

I have a simple, flat database that I use for creating certification exams for my professional association. Each question has a repeating field that records the links to the major topics. I set it up this way for inquiry purposes: by doing a "find" on the repeating field, I find all questions related to that topic.

I would also like to be able to count the number of questions that reference each topic. I can do this manually through a series of "finds," but with almost 50 topics, that's obviously less than ideal.

I know that I can count the total number of entries in the repeating field, but that's not what I need.

Any ideas?

I'm using FM Pro 13.0 on a MacBook Pro running OS X 10.10.2.

Outcomes