I have a big question with multiple little questions.
I hope I can explain this well. I have attached the filemaker file to help.
1. In the table written data a student took multiple parts of a test and received a grade. The only data I am looking for is Total Score. Which I need to move to the Pass/Fail Table and only need one record of which must contain the first name, last name, Participant ID, Test Score, and Test code (which this data needs to be put in the Written Data Test Score field).
2. In the Table Performance Data a student took multiple parts of a test and received a grade. Again the only data I am looking for is Total Score. Which needs to match the above student and be put in Performance Data Test Score Field.
3. I know that I need to have the three (Written, Performance, and Pass/Fail ) tables related, but I am not sure how to get the Participant ID in the Pass/Fail Table because I am not importing data in that table to compare.