Can Related Records Be Viewed Like Fields?
I need to have a CSV file exported from FM Pro that has student names in the first column and each run grade in subsequent columns. Currently, I have Table_Students with fields Student_Name and __pkStudent_ID. I have another table, Table_Runs, with fields _fkStudent_ID, Run_#, and Run_Grade. The table, Table_Runs, contains multiple runs for each student, 10 runs to be exact. How do I do this, if I can do this? The picture is of the CSV file I need.