Count number of records with matching IDs

[tapededitions]

I would like to set up a field that counts the number of records I have that have identical IDs.

For example I have a book the the ISBN 156740393x. I want file maker to count how many books we own with that ISBN.

Is this possible?

Mindy

[RussBaker]

Create the following 2 fields:

code:

---

SummaryISBN = Count of ISBN [this is a Summary field]

Quantity_of_This_ISBN = GetSummary(SummaryISBN,ISBN) [this is a calculation field]

On your layout, the Quantity_of_This_ISBN field will now display the total number of records which have ISBNs matching the ISBN in the record.

If you want a list showing how many of each ISBN you have, then create a layout with a sub-summary part sorted by ISBN. In this sub-summary part, place the ISBN and SummaryISBN fields. You can delete the body part.

Now, sort your records by ISBN as the first sort field, go to the new layout and enter preview mode. This will now display a list of each ISBN and the quantity held.

Russ Baker

[ March 28, 2002, 06:55 PM: Message edited by: Russell Baker ]

[danjacoby]

Or you could create a self relationship (ISBN::ISBN), and a calc field equalling Count(Relationship::ISBN). Then you can show the sum in any layout in Browse mode.

[Rigsby]

Use Dan's sollution!

It will work better in the long run.

However, with large numbers of records, both the above methods will slow things down a lot.

Rigsby