how to add number count to FMP database

Discussion created by vdubbeet on Sep 12, 2012
Latest reply on Sep 13, 2012 by rivet

I'm working on a DB that consists of various choirs, singers, parts, etc and the directors have asked for a count of active participants in each choir. I was thinking about putting in a field where a dynamic number appears whenever the DB is sorted by choir, singer, etc and the last singer of the choir will have a number next to them that displays the count. I hope I'm describing this properly. I do not know how to do what I'd like to do. Thanks in advance for your help!