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.