Jump to content

Display data from multiple rows


Indiayque

This topic is 6516 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6516 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.