Robert Lauriston

After FileMaker tech support told me it was impossible, I got a simple solution from RalphL in the Layouts section: do the report showing records from InstructorAssignment (instructors-classes join table), and make the body of the report a portal to ClassEnrollment (classes-students join table). That way, all the foreign keys are in the report, and everything works as required. Thanks.

Thanks, Ralph, that works perfectly. FM tech support sure dropped the ball on this one. I guess the key is basing the report on the instructors-classes join table and making the body of the report a portal to the classes-campers join table (even though the actual fields of the report mostly aren't in either of those tables). Bruce, thanks but the modified file you posted in the other thread had just one sub-summary by class, which showed both instructors.

For a class-enrollment application, I've got a set of classes that sometimes have multiple teachers and always have multiple students, i.e. two many-to-many relationships with join tables. One of the requirements is for a grouped-data report that's supposed to look basically like this: sub-summary by teacher - sub-summary by class (each teacher has four) -- list of enrolled students (5-20) The goal is to get a big report that can be broken out into a printout for each teacher listing the students in each of their four classes. (If classes had only one teacher, this would be easy.) When I do the report with "Show records from" set to the teacher-class join table the report shows only one student per class. If I change "Show records from" to the student-class join table, I get only one class per teacher. Makes no difference whether I use portals. I spent a couple of weeks going over this with Framemaker tech support and they say I need to create a denormalized table for the report. I've never had to do this before and I don't know where to start. Any advice?

Thanks, but that doesn't produce the required results. Framemaker tech support says there's no way to get what I need without creating a denormalized table, so I'll repost in the reports section.

No luck, same results with the portal as without.

Sliding might do the trick, I didn't realize you could do that on a portal. Thanks!

For a class-enrollment application, I've got a set of classes that sometimes have multiple teachers and always have multiple students, i.e. two many-to-many relationships with join tables. One of the requirements is for a grouped-data report that's supposed to look basically like this: sub-summary by teacher sub-summary by class names of enrolled students & related data The idea is to get a printout for each teacher showing all their classes and which students are enrolled. The problem is that if I do the report with "Show records from" set to the teacher-class join table the report shows only one student per class. If I change "Show records from" to the student-class join table, I get only one class per teacher. I can't use a portal because the number of students varies too much. I guess I could kludge a denormalized table just for this report, but it seems like there ought to be a more elegant way. Any other suggestions? Is this maybe a bug in v.7? Here's the schema: http://www.lauriston.com/schema_v2.gif Here's the file itself: http://www.lauriston.com/Camp2004v2.zip