Enter find mode Enter "Managing" in the category field, then click new record, then enter "Attempting" in the category field, then click perform finds.
Not quite sure i follow, I need this as a script and have now got to this point, but it is not working
Enter Find Mode [ ]
Set Field [Pupils::YearGroup; Globals::YearFind]
Set Field [Mathematics::AchievementScale; Globals::MathsAchievement]
Perform Find [ ]
Go to Layout ["ClassListFinds" (Pupils) ]
if [Globals::MathsAchievement = "Managing"]
Extend Found Set [Restore]
The extend found set contains the equation
Mathematics::AchievementScale = "Attempting"
To add an or to your search. After the second set field, you will add new record request, then use set field again for the second Achievenment you want to search. You will have to have more than one global fields.
Won't add new record/request create a new record in the database?
What is extend found set for if not this situation?
You could also add a calcualtion field to the table that returns a number for each of these values that ranks them in the desired order. You can then enter find criteria with an inequality operator in this calculation field to find all records with "managing" or below.