I have a summary problem:

Each record belongs to one of 14 main areas. Each of these areas has 9 more subdivisions, and each of these is further subdivided into 7.

Let's name one of the 14 as AI, the next divisions are named 1 through 9 and the last subdivisions are named A through G. I need to produce a summary of each of the respective combinations. Such as

AI 1 A......AI 2 A......AI 3 A......AI 4 A......AI 5 A

AI 1 B.....AI 2 B......AI 3 B......AI 4 A......AI 5 A......and so on.

I can accomplish this by using a Find based on the 3 divisions, Status (CurrentFoundCount), and setField. However there are about 882 combinations. Surely there is a better way than doing 882 find scripts.

As usual any and all help is appreciated.

Al

Create a subsummary part based on the combination field, then sort on it and print the report. It'll divide everything up for you.

Yes, this does show the divisions and the records within each. I failed to mentioned that it is the actual record count of each division that I need. And these record count numbers need to be placed within their appropriate

What about using some relationship here and use the Count (relationship) function for any Division, Group, Department,...

This is quick and reliable...

Hey I have a problem like yours and I also need help. If you can remember what you did anytime, please let me know.

Arty.

May be it would need some adaptation, but here's how you can do this.

Let's call the Groups "Main Group", "Division" and "Department".

You'd agree that :

- a Department is linked to a Division and a Group

- a Division is linked to a Group.

What you need is a file with these fields :

1. Category ------> return the category of the current record ----> Main Group, Division or Department

2. Serial#

3. a Record_ID autoentered by calc "ID"&Right("00"&Serial#,5)

4. Group_ID and Group_Name

5. Division_ID and Division_Name

6. Department_ID and Department_Name

Each field would be populated by the referenced Ids, the Record_ID being attributed to the current "Group" according to the category selected.

7. A set of 3 calculations that will return the current Group_ID, Division or Department_ID, this way :

c_return_Group ID = Case(category = "Main Group", Main Group_ID, " ")

c_return_Division ID = Case(category = "Division", Division_ID, " ")

c_return_Dept ID = Case(category = "Department", Department_ID, " ")

8. A Multikey Calculation = Group ID&"PP"&Division ID&"PP"&Department ID

Therefore a Department would have a Multikey composed of 3 Ids (Group, Division and Department), a Division would have a Multikey composed of 2 ids (Division and Group) while a Group would have only its own Key.

Some more settings could be suitable, but you can start with this.

Therefore, you understand that you can relate c_returnGroup_ID with the Multikey and you'll therefore have a list of all divisions and departments related to that ID...

To have a better view of what this could be, just download the sample "records in folders" in the Sample Section as it is a slightly near adpatation from this technique.

See attached a sampler with 7 groups, 9 sub groups and 7 departments.

882subdivided.fp5.zip