In your Relationships Graph, create a self join relationship by duplicating your Table.
Set the relationship so that the INDIVIDUAL item id ≠ to INDIVIDUAL item id and GROUP id = GROUP id
then create a calculation field using the following:
Count ( ***RELATEDTABLE::ITEMID )
***Substitue with your actual table name an field name
One solution is to use a summary report rather than a table view. You can group your records by this field by sorting them and if you place all your fields in a sub-summary part and removed the body layout part, you can get a table like list of records with one row for each type of record and a summary "count of" field can give your the number of such records in each group.
You can also list your records in a table view and count the records with a self-join relationship and a calculation field that uses the "count" function.
In Manage | Database | Relationships, click on your alpanumeric field, drag from it outside the table occurrence box and back to the same field. This creates a new table occurrence related to the first by your alphanumeric field.
Table::AlphaField = Table 2::AlphaField
Now you can define a calculation field such as Count ( Table 2::AlphaField ) to compute the total number of records with the same exact value in this field. This table view will still list all copies of each record (Don't know if that's what you want or not) but it will display your record counts as requested.
Many thanks Phil. And apologies for not providing useful info like version operation system, etc. Just to fulfill that, I'm on a Mac Pro (OS 105.7) using FM 11 Advanced. It is not currently on a server, but soon will be, along with FM 11 Server.
Again thanks for the help. I really appreciate it. I'll try to get this code done by the end of the day and report back by Monday.
It works perfectly! Again, many thanks! That saved me a lot of time.