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
Finds through relationships are slow Questions perform-find	20	752	December 21, 2020
Confusing 1 to Many Find behavior with relationship sorted by Date Questions relationships	11	503	October 16, 2022
Get(foundCount) not working properly Questions community , functions	2	453	September 18, 2020
Global Portal? Questions community	9	626	September 8, 2020
Having problems with script Get(FoundCount) scripting	8	131	May 10, 2025