AnsweredAssumed Answered

Help with summary of 'similar' fields

Question asked by RyanFishy on Jan 13, 2011
Latest reply on Jan 14, 2011 by RyanFishy


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.