Subsummary fields

[2 letter pi]

In FileMaker V6.0 in Windows 2000...

I have two databases.

The first one is manly for demographic info (name, address, phone, etc.) It does not duplicate names.

The second one is for listing and counting contacts during the year.

The number of contacts for each name in the first database varies

[Ender]

Put your report in the Person file. Use a calculation to count the number of contacts:

ContactCount (calculation, number result) = Count(Contact::ContactID)

Find and sort by this for your report. Finds and sorts on aggregate fields like this will be slower, but should give you the results you need.

[2 letter pi]

:crazy:

Thanks for the advice on how to create a field to sort by and find by "counts" of contacts. IT WORKS....(sort of). It will give me an accurate count of the number of contacts in the Contacts file but it seems to ALWAYS giev me the total number....period. I need to get a total for records for a given date range rather than the whole database.

.

Any clues to what I am doing wrong?

.

.

PS - For training someone like me (not a novice but ALL self-taught) what woul dyou recommend for training, either live or via CD??

.

AGAIN, THANK YOU for taking the time to help!

[Ender]

Since you only want to count a subset of the contacts for a Person, you will need to filter the relationship to show only that subset.

In FM5/6, it's pretty tricky to include a date range in a relationship (check out Mikhail Edoshin's Smart Ranges technique for specifics.) Alternatively, you could filter by Month and Year. This would be done by adding globals for the Month and the Year to the Person file, then having a calc concatonate those globals with the PersonID to make a concatonated key on the parent side. Then you'd need to have a corresponding concatonated key on the child side that takes the Month of the contact, the Year of the contact, and the PersonID and puts them all together. Define a relationship between them in the Person file to get your filtered relationship.

Put the Month and Year globals on a layout so they can be set by your users. Maybe attach value lists to them so they will be in the right format. With values chosen in the globals, the relationship should show corresponding related Contacts for that Month/Year.