Random number for a subset help

[sujag]

This is the problem. Quiz Database. I have one database that stores several different cateogories of questions. Once I find the subset of questions, I need to randomly pick a certain number of questions for a test. When I tried it, the randomly picked questions are from the whole database not just the subset(category) of questions.

I am thinking I need a field to mark as the found set and then have the random number generator pick from that marked set. But how?

Thanks in advance for any help!!!

[BobWeaver]

Create a new field called RandomNo. Suppose you want 10 random questions out of the subset.

Start with RandomNo cleared to 0 in all records.

Select your subset.

Using Replace or a loop, set RandomNo to a random number (surprise!) in all records in the subset.

Sort on the RandomNo field to randomize the set.

Now, if you want say 10 questions out of the subset, use a loop to omit records until there are only 10 left

code:

---

show all records

replace [RandomNo, calculation = 0]

# select your subset here

.

.

.

# randomize

replace [RandomNo, calculation = Random]

# sort on the RandomNo field

sort [RandomNo]

go to record/request [first]

loop

exit loop if status(currentfoundcount)<11

omit record

end loop

---