3 Replies Latest reply on Mar 18, 2012 5:37 AM by comment

    Chart Multiple Fields in the Same Record?

      I have a grade book. I want to make a single chart for each student showing their grades for each of three quizzes. How do I do that?

       

      Ex:

       

      Database

       

      First Name: John

      Quiz 1: 80

      Quiz 2: 70

      Quiz 3: 90

       

      Now I want a chart that looks like this:

       

      "Quizzes"

      100

      90 000

      80 000 000

      70 000 000 000

      ... 000 000 000

      0 000 000 000

      Quiz 1 Quiz 2 Quiz 3

       

      And I have 60 students, and I want one for each student.

        • 1. Re: Chart Multiple Fields in the Same Record?
          comment

          To solve your immediate problem, define the chart to use data from current record. For the X axis, specify a calculation =

           

          "Quiz 1¶Quiz 2¶Quiz 3"

           

          For the Y axis, specify a calculation =

           

          List  ( Quiz 1 ; Quiz 2 ; Quiz 3 )

           

           

          In the long run, each grade should be a record in a related table.

          • 2. Re: Chart Multiple Fields in the Same Record?

            Thanks, Michael.

             

            You mentioned keeping grades in a related table. What would be the best way to design a database like that? I'm learning FM Pro and loving it. But I'm still trying to learn how to make it work for the classroom. So separate tables for each assignment, then?

            • 3. Re: Chart Multiple Fields in the Same Record?
              comment

              AustinKocher wrote:

               

              So separate tables for each assignment, then?

               

              Heavens, no. A separate record for each assignment in the Assignments table, and a separate record for each grade in the Grades table. A record in the Grades table would look like this:

               

              GradeID (auto-entered serial number)

              StudentID (matchfield to the Students table)

              AssignmentID (matchfield to the Assignments table)

              Grade

              Notes

               

              and your relationship graph would be:

               

              Students -< Grades >- Assignments