Display data from multiple rows

[Indiayque]

I'm a beginner and need some assistance. I have a student database with multiple related tables. One of these tables is a test scores table. The testscores table has multiple rows for a student. The rows have a student id (key), test id (e.g. SAT or ACT), test component (e.g. Verbal, Math, etc) and a test score. Rows - e.g. one row with 0001 SAT Verbal 800, another row with 0001 SAT Math 800, another row with 0001 SAT COMPOSITE 1600.

I can display this test info in a portal for each student, but I want the test info displayed in table so I can export it to Excel as one record for each student.

Where do I start?

[John Mark Osborne]

You could start by trying the new Save Records as Excel feature in FIleMaker 8. It will take all the fields on your layout (including the ones in a portal) and export them to Excel. But, it will place the scores on separate rows in the same column and it sounds like you want the scores on the same row in separate columns. Try this file out and let me know.

students.fp7.zip

[Indiayque]

It's almost what I need. Is there a way to output not only the score but also the test name. So the score1 will show not just 800 but SAT Verbal 800 ?

[Indiayque]

OK. I used my noodle. I joined the fields I needed in the scores table using a calculation. Then the coding in the student table seems to display exactly what I need. Many thanks, John!