AnsweredAssumed Answered

One to many in a report/layout

Question asked by meschj on May 11, 2009
Latest reply on May 11, 2009 by philmodjunk

Title

One to many in a report/layout

Post

I'm a newbie to Filemaker, and have worked with databases but more on the data manipulation and less on the reporting.

 

I'm trying to create a report that provides a list of textbooks by course for students. 1 page per student.

 

I've got 3 tables of information:

 

Students

-ID #

-Name

 

Schedules

-student ID # (matches the similar field in students table)

-course #

-teacher

 

Couses

-course # (matches the one in schedules table)

-course name

-book1

-price1

... (book2, price2, etc)

 

I have relationships defined tying the student ID # fields and then the course # fields.

 

I basically need the student name & ID number across the top. Then (for each course) the course name, course number, and teacher on a line, then immediately below the books and prices for that course.

 

I've played with leading and grand summaries, sub-summaries, and the body, and even portals, but can't seem to get all the courses to list for each student. All I get is the same information repeated down the page.

 

Any suggestions?

Outcomes