Show total of fields from one table in another table's layout
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:
When I look at the student information layout with the calculated field there is nothing there.
What am I doing wrong??