I have a file with student records. Each student has its own information and a parent id. I need to determine how many children are in each family and pritn a report that is sorted by that number. For example Davey Jones might have 5 children in school. Tom Lasorta, 4. Anna Frank, 5. It should come out with a 5 children group displaying Frank and 5 children, and Jones with the 5 children info. Then the 4 children section with Lasorta and children info. As I mentioned, I can differentiate parents using the parent id.

Thanks,

Mike

I failed to mention this file is in FMP 6.

Mike

You can use a columnar report with sub-summary parts, having a Sub-Summary by ParentID part where you can put the Parent Name(s) along with a Count of RecordID summary field.

In order to get the parts to summarize and sort the way you want, you should Sort by ParentID, and reorder by the Count of Records summary field.

Hmm, in FM6, I think this is a little different.

I think in this case you would need to define an aggegate calc in the Parent file:

NumberOfChildren (calculation, number result) = count(Child::ChildID)

Then sort and sub-summarize by this for the sub-summary report.