# Finding the last three records containing each value in a set of values

**URL:** <https://the.fmsoup.org/t/finding-the-last-three-records-containing-each-value-in-a-set-of-values/4480>\
**Category:** Questions\
**Tags:** scripting, sql, filemaker\
**Created:** [November 19, 2024, 10:39am UTC](https://the.fmsoup.org/t/finding-the-last-three-records-containing-each-value-in-a-set-of-values/4480 "2024-11-19T10:39:48Z")\
**Posts on this page:** 5\
**Page:** 2

<div class="post-metadata">

**Author:** ![Malcolm](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/malcolm/32/196_2.png) [@Malcolm](https://the.fmsoup.org/u/Malcolm)\
**Post date:** [November 29, 2024, 7:21am UTC](https://the.fmsoup.org/t/finding-the-last-three-records-containing-each-value-in-a-set-of-values/4480/21 "2024-11-29T07:21:54Z")

</div>

You can think of Table Occurrence Groups as analogs of views. The primary table relationships are based on the formal underlying relationship. However, you can make special purpose groups of tables with funky relationships to achieve special purposes.

---

<div class="post-metadata">

**Author:** ![xochi](https://avatars.discourse-cdn.com/v4/letter/x/0ea827/32.png) [@xochi](https://the.fmsoup.org/u/xochi)\
**Post date:** [November 29, 2024, 6:52pm UTC](https://the.fmsoup.org/t/finding-the-last-three-records-containing-each-value-in-a-set-of-values/4480/22 "2024-11-29T18:52:18Z")

</div>

Good point. It would be really cool if FileMaker extended that analogy, and allowed you to have calculated fields that are specific to a Table Occurrence.

(As a consolation prize, I'd be satisfied if the Table editor would allow us to visually group calculation fields inside a folder structure to keep things neat & tidy).

---

<div class="post-metadata">

**Author:** ![Malcolm](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/malcolm/32/196_2.png) [@Malcolm](https://the.fmsoup.org/u/Malcolm)\
**Post date:** [November 30, 2024, 6:34am UTC](https://the.fmsoup.org/t/finding-the-last-three-records-containing-each-value-in-a-set-of-values/4480/23 "2024-11-30T06:34:32Z")

</div>

There is nothing stopping us from creating virtual tables. @BrentBollmeier you may want to look at this technique. Search for virtual tables and/or Bruce Robertson.

---

<div class="post-metadata">

**Author:** ![planteg](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/planteg/32/627_2.png) [@planteg](https://the.fmsoup.org/u/planteg)\
**Post date:** [December 1, 2024, 12:07am UTC](https://the.fmsoup.org/t/finding-the-last-three-records-containing-each-value-in-a-set-of-values/4480/24 "2024-12-01T00:07:12Z")

</div>

Virtual tables are an interesting way to create a table that would be hard, not say impossible, to create by usual means. All calculations are done in a script, no unstored calculations that take age to compute. All thats is needed to refresh the virtual table is to call the script that creates it !!!

---

<div class="post-metadata">

**Author:** ![Malcolm](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/malcolm/32/196_2.png) [@Malcolm](https://the.fmsoup.org/u/Malcolm)\
**Post date:** [March 4, 2025, 8:32pm UTC](https://the.fmsoup.org/t/finding-the-last-three-records-containing-each-value-in-a-set-of-values/4480/25 "2025-03-04T20:32:01Z")

</div>

2 posts were split to a new topic: [How does FileMaker differ from Oracle?](https://the.fmsoup.org/t/how-does-filemaker-differ-from-oracle/4690)

[Previous page](https://the.fmsoup.org/t/finding-the-last-three-records-containing-each-value-in-a-set-of-values/4480.md?page=1)