AnsweredAssumed Answered

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

Question asked by MichaelHemberger1003 on Feb 9, 2012
Latest reply on Feb 9, 2012 by philmodjunk

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??

Outcomes