Consider this setup, for a student/assignment grading database: Student Table: ID gAssignmentKind Scores Table: StudentID AssignmentKind Score Each student has 1 or more Scores in the Score table - but there's never more than one StudentID + Kind + AssignmentID combo per student in the score …

Find through global fields giving odd results

xochi February 17, 2023, 9:42pm 5

Here's a test file (about 200KB zipped)

username/password = admin/admin

vs.

FMS19.6.3 poor performance on M1 mini / Ventura

Topic		Replies	Views
Caveat on Creation via relationship (no records in first table) Heads-Up! scripting , relationships , filemaker	1	242	September 28, 2023
Global Portal? Questions community	9	620	September 8, 2020
Confusing 1 to Many Find behavior with relationship sorted by Date Questions relationships	11	499	October 16, 2022
About relationship predicate order making a difference Heads-Up!	3	398	July 30, 2020
FM: Fields with Global Storage Wiki	13	1058	April 1, 2020