Counting occurrences in repeating fields
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.
I'm using FM Pro 13.0 on a MacBook Pro running OS X 10.10.2.