AnsweredAssumed Answered

Can Related Records Be Viewed Like Fields?

Question asked by cmspe on Dec 7, 2012
Latest reply on Dec 10, 2012 by cmspe

Title

Can Related Records Be Viewed Like Fields?

Post

     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.

     Table_Students                    Table_Runs

     __pkStudent_ID------------<_fkStudent_ID

     Student_Name                    Run_#

                                                    Run_Grade

Screen_Shot_2012-12-07_at_10.06.11_PM.png

Outcomes