How to get Cum GPA from another Tables GPA
I'm new to Filemaker Pro.
I have 2 tables:
Table 1: id, Name, Cum GPA
Table 2: Table1ID, id, Semester, Subject1, Subject2, Subject3, GPA
-> "GPA" column in Table 2 is auto calculated based on Subject1, subject2 and Subject3
--> I want "Cum GPA" column, in Table1, auto calculated based on "GPA" Column from Table 2 for every semester with the (Table1:id = Table2:Table1ID).
How can I do this..??
Thanks in advance.