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.
1 Like
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).
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.
2 Likes
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 !!!