How to group and count
I have read through so many posts on this issue, but I can't figure it out and would really appreciate some help. What I am trying to do is similar to my SQL days when you could create a group by query that counted the number of records on one or more fields. In FileMaker I need to be able count the number of different alert types I have created. It is dynamic and changes all the time. What I really would like to do is get these values and then insert the unique rows with unique counts into a separate table - then with that table I can use it on a dashboard type concept.