The problem is that when I try to sort these question record subsets by random number, they are not sorted.
I do not see the why you want to sort by the random number those random questions.
To be more precise, I am manually selecting a set of records (questions) from the large bank. Then I "find" this set of records, which I need to randomly sort.
I can't just make a random number for each record in the large bank once, then use it again and again. I need to make a NEW random number for each record in the found set, each time I do this. Hard to explain why. These are question sets for a professional contest, and some are re-used from time to time...need to be certain that they do not occur in the same or even a similar order.
Thanks for working on this.
Create a new number field and in a loop script
Set Field RandomField ; Random
Then sort on new field
This looks promising. I'll see if I can make this work.
Yes, that works. Very good. Thanks a lot.