Help linking/grouping with multiple tables

[swright]

I am using CR 8.5 with an Access MDB file containing multiple table with indexed fields. I need to group at four levels as follows:

Group 1 (based on parameter selection of [Teacher,Grade,StudentName]

Group 2 - StudentName

Group 3 - PrintPriority

Group 4 - ClassTeacher

The tables are as follows:

Students->Grades->CourseID->SystemID->PrintPriority
->ClassID->ClassTeacherID

The first two groups are simple. Groups 3 and 4 are causing me problems because I need to group (sort) on PrintPriority AND on ClassTeacher, which are linked from the same indexed field in the Grades table, but are separated from it by one or more "translation" tables, each containing an indexed field which translates to one or more records in the next table. (ie: there can be several ClassTeachers for a single Grade record. There should only be one PrintPriority for each Grade record.)

When I group on level 3, it appears every record of Grades is read for each value of PrintPriority. I can possibly do without Group 4, if I can work out how to deal with Group 3 properly.

Any ideas welcome, thanks.

 

[swright]

Sorry, just to clarify, the Teacher field referred to in Group 1 is NOT the same as the ClassTeacher field in Group 4. The Group 1 Teacher field is stored in a linked table which I did not show, since it doesn't impact the problem I am having.

 

[Madawc]

When I group on level 3, it appears every record of Grades is read for each value of PrintPriority

Yes, that's how Crystal grouping is supposed to work. What are you wanting it to do?

One common method is to put details in a group header or footer and suppress the detail lines. Would this help?

You can also group on a formula field that might have two fields, or a choice of fields that may depend on a paramter.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10