OK, one more question from me today.

In a job database I have a list of jobs with different priorities and dates. I want to write a script to sort the jobs by priority, then by date, and then by time. I can get that far just fine.

I'd then like the script to go down the list and assign a field in each record a numerical value representing that job's location in the queue.

Any suggestions?

I think the function you're looking for is Status(CurrentRecordNumber), which will change according to a record's position within a found set and sort order.

Hi there,

My suggestion:

Make a new field named "Number"

After your first step sorting the items in right order:

Go to first

Go to field Number

Replace with serial numbers, Custom values, Initial value 1, Increment by 1

and perform without dialog.

Im not sure if you should mark "Entry serial numbers in Entry Options"

but try with and without.

I use this and its work good.

Good luck.