Using data from a join table in a report

[fiona_at_VAS]

I'm trying to generate a report of course units completed by students with one line for each student showing:

 

Student Name: Course Unit A, Course Unit B, Course Unit C.

 

Students to Course Units is a many to many relationship, so I've set up a table for students and a table for course units and a join table.

 

Student Table:

Student ID

Student First Name

Student Surname

 

Course Units Table:

Course Unit ID

Course Unit Name

 

Student Course Join Table:

Student ID

Course Unit ID

 

I can use a portal to display the information from the join table, but I can't work out how to create a report with a single line for each student. Any assistance would be gratefully received!

 

I'm working on this on a Mac and am using Filemaker 7 for this particular database.

[David Head]

Hi Fiona

Are there only ever three course units? Always the same three?

What you are trying to set up is called a cross-tab table and it is reasonably simple if there are a fixed number and description of the columns.

 

Let me know and I can do up a sample file for you.

[fiona_at_VAS]

Hi David,

 

many thanks for your reply.

 

Unfortunately no, there will be many different course units (possibly hundreds) and students may take different combinations of the units. New units will need to be added from time to time.

 

Fiona