如何从相关的过去记录中检索数据 [英] How to retrieve data from related past records

问题描述

我正在使用Filemaker Pro12.我想创建一个学生报告，其中包含以前条款的结果.例如，每年有4个学期.第1期中的报告仅包含第1期的结果.但是在第2期中，报告同时包含第1期和第2期的结果.此过程一直持续到第4期(年末)，该报告将包含第1期的结果. 1至学期4.

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.

我在Results表中创建了4个字段ca1_percent，sa1_percent，ca2_percent和sa2_percent.我的Results表包含过去结果的所有记录.我的关系图如下图所示:

I created 4 fields ca1_percent, sa1_percent, ca2_percent and sa2_percent in the Results table. My Results table contains all the records of the past results. My relationship graph is shown in the diagram below:

我的问题是我一直仅从CA1获取记录(mark_percent).我的字段计算如下图所示:

My problem is that I kept obtaining the records (mark_percent) from CA1 only. My fields calculation is shown in the diagram below:

有人可以帮助我吗?

更新: 我从上面获得的结果如下图所示.我已经填写了第3学期的结果.

Update: The result I obtained from above is shown in the picture below. I have populated upto term 3 results.

推荐答案

只是想一想-可以使用ExecuteSQL()查询来获取相关ID作为值列表，然后将其插入ID-1，ID-2， id-3更灵活吗?

Just a thought - might an ExecuteSQL() query to fetch the related ids as a value list, then plonking them into a id-1, id-2, id-3 be more flexible?

这篇关于如何从相关的过去记录中检索数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！