Help with summary of 'similar' fields
I'm working FM Pro 11
We have a single-table database with about 10k records. There is a non-unique field called 'Accession Number.' We have about 5k different accession numbers. I would like to place into a layout a 'summary' that would count how many times the current record's 'Accession Number' field's value appears in the database across all records. This would mean that each record would display a count of how many other records shared its 'Accession Number'
Thanks for any help with this simple question, still trying to wrap my head around relational databases.