Hi.

I have build a project-management system in FMP 6.0, based upon three levels: Projects, Orders and Activities. Theese levels are separate files that are related to each other. Activity to the Order-ID, and the Order to the Project-ID.

I would very much like to make a report from the Project, displaying all related Orders and Activities in a heirarchical tree structure - just like this:

Project: Description + other fields from record

Easy, start by making a ProjectID field in your ActivityDB. This can simply be a calculated field showing the ProjectID from the related Order record.

Now Sort by ProjectID, OrderID and whatever Activity fields you want.

Setup a report (in the ActivityDB) with sub-summary parts by ProjectID and OrderID.

You can substitute some other unique fields for ProjectID and/or OrderID as it may make for a more logical report if sorted by say ProjectName and OrderNumber or whatever.

That works just perfect!!!

Thanks a million!

P.