AnsweredAssumed Answered

Help tracking students' exam results

Question asked by brian47933 on Nov 3, 2015
Latest reply on Dec 9, 2015 by brian47933

I am in desperate need of guidance. I'm new to FileMaker.


I want to keep track of students and their exam results.


I have many students who take many exams. So this is a many-to-many relationship. I think I need a join table.

The data is coming from a collection of Excel worksheets. I have standardized the column names and just collect some information from each worksheet (Speaking, Writing, Listening, Reading, Overall scores). This is a standardized test which is given multiple times. A student can take it one or more times.


I am confused how to set this up in FileMaker Pro 13.


I have a students table. On the student detail layout I have a tabbed window. I want the above results to appear on the tab. This should be done with a portal, pulling the data from the join table (I think).


Am I going in the right direction? I'd like to get this done as soon as possible. I have another round of exam results coming up.


Thank you in advance for your time.