AutoEnter Ascending number in to a field (ranking)

[papacubby]

I have searched for help on this with no results. Using WINDOWS and FMP 6.0v4.

Here is the situation: I have a database with 419 records, and four fields: "Names", "number of push-ups", "Grade" and "Ranking".

After I do a find for the students I am looking to number. I would like to write a script that would go to the

[-Queue-]

If your file is single-user, then

Go to Record/Request/Page [First]

Replace [No dialog, Ranking, Serial numbers]

should work, where you select 'Custom values' under 'Replace with serial numbers' and use the default 1, 1.

If it's multi-user,

Go to Record/Request/Page [First]

Set Field [gNum, 1]

Loop

Set Field [Ranking, gNum]

If [status(CurrentError)]

{perform action if record is in use by another user}

End If

Set Field [gNum, gNum + 1]

Go to Record/Request/Page [Exit after last, Next]

End Loop

where gNum is a global number field and the action can be appending the current serial to a global field, a warning message to the user that the process can't be completed, or something similar.