My brain just won't wrap around this one. I've got students in one table (including a field for what "team" that student is on) and possible courses in another. Each student ranks his preference for the various courses and is ultimately assigned a few of them. I've got a join table with StudentID, CourseID, preference, and whether assigned.

I do just fine with a report sorted by course, sub-summary by team, then listing the students assigned to that course who are from that team.

But I get stuck going from the other direction: I want to show the student's name, each course they are assigned to, plus the name of any other student from their team who has also been assigned to that course. It is that last pesky detail that twists my brain. How do I do this in FMP 10?

Thanks

I get stuck going from the other direction: I want to show the student's name, each course they are assigned to, plus the name of any other student from their team who has also been assigned to that course.

Is this also a report? If I understand this correctly, each student would be listed many times (more times than the number of courses they have been assigned to)?