title: How to retrieve data from related past records
body: <p>I am using Filemaker Pro 12. I want to create a student report that contains results from previous terms. For example, each year there are 4 terms. The report in term 1 contains only the result of term 1. But in term 2, the report contains the results from both term 1 and term 2. This continues until term 4 (end of year) which the report will contain the results from term 1 to term 4.</p>
  
  <p>I created 4 fields <code>ca1_percent</code>, <code>sa1_percent</code>, <code>ca2_percent</code> and <code>sa2_percent</code> in the <code>Results</code> table. My <code>Results</code> table contains all the records of the past results. My relationship graph is shown in the diagram below:</p>
  
  <p><img src="https://i.stack.imgur.com/3v6v4.png" alt="enter image description here"></p>
  
  <p>My problem is that I kept obtaining the records (<code>mark_percent</code>) from CA1 only. My fields calculation is shown in the diagram below:</p>
  
  <p><img src="https://i.stack.imgur.com/kphS4.png" alt="enter image description here"></p>
  
  <p>Can anyone help me?</p>
  
  <p>Update:
  The result I obtained from above is shown in the picture below. I have populated upto term 3 results.</p>
  
  <p><img src="https://i.stack.imgur.com/WQf89.png" alt="enter image description here"></p>