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
Global Portal? Questions community	9	568	September 8, 2020
About relationship predicate order making a difference Heads-Up!	3	375	July 30, 2020
Caveat on Creation via relationship (no records in first table) Heads-Up! scripting , relationships , filemaker	1	210	September 28, 2023
Scripted find fails "set field" step Questions scripting , find	2	262	March 20, 2021
Confusing 1 to Many Find behavior with relationship sorted by Date Questions relationships	11	436	October 16, 2022