I have a table of Students records related a table of their Grades. There is a one Student record to many Grades records relationship (e.g. a record in the Grades table for each subject a Student studies).

Each Grade has a field for "year". As we move into a new academic year, I want to restrict finds on the Grades table to grades for the new year only (i.e. find only those records from the Grades table with an entry of 2006 in the year field, excluding those for 2005, unless the user specifies 2005 in the Year field explicitly).

I also have a table with a single record which has constants such as the school name etc, and the current academic year (now set to 2006).

Q: How can I get my find script to use the value from the current academic year field in the Constants table (record 1) so that only grades for the current year show up when searching the Grades table?

As a quick fix just now, I've just restored find requests to GradeYear = 2006 in the script, but this will require updating each year.

You can use the 'Set Field' script step to set the field in find mode. This could either be set from data you have previously stored in a Global field, or if you upgrade to FMP 8 a script variable.