Summary - not summing my way

[grumbachr]

This is what I'm trying to say with a couple summaries; "I have X number of Samples that have come from Y different families (Y can be the same number as X but never more)"

Details... using 2 tables; Contacts and Samples relationship is based on Contact ID. Contacts are also part of a Family and have a Family ID (Family ID is part of the same Contacts Table, it is not its own table). I'm trying to generate a report of all samples (easy enough) Sorted by Family ID (still easy). The report layout has a Sub-Summary when sorted by Family_ID, (still pretty basic) and this is working perfectly.

I now need two Summaries. The first is straight forward and working fine, basically total found records.The second is the one I need help with. I need a total/count of unique Family IDs used.

I've tried creating a calc field that counts the Family ID's then a summary of that field but the calc counts each individual record not just uniques each unique family ID so I end up with the same totals.

Thanks and as always any suggestions are appreciated.

[comment]

See:

http://www.fmforums.com/forum/showpost.php?post/297916/

Note that GetSummary() will NOT work with a related breakField, so just make yourself an unstored calculation field in the Samples table =

Contacts::Family ID

and use that instead (for sorting and the sub-summary part, too).