1 2 Previous Next 16 Replies Latest reply on Feb 9, 2012 1:09 PM by philmodjunk

    Show total of fields from one table in another table's layout

    MichaelHemberger1003

      Title

      Show total of fields from one table in another table's layout

      Post

      This should be so simple, but I can't get it to work.

      I have two tables. One is student information and the other is student payments. They both have a keys(studentId's) and are joined from student information to student payments. The student payment record has a Payment_Charge numeric field. The student information table has a  Total_Of_Payments field.

      The Total_Of_Payments field is located on the layout for student information. It is a calculated field looking like this:

      Sum(Student_Payments::Payment_Charge)

      When I look at the student information layout with the calculated field there is nothing there.

      What am I doing wrong??

        1 2 Previous Next