Generate Random Records, So Confusing ...

[youkn0wwho]

I'm using FileMaker Pro 6 for my computer assignment - creating a test. After entering the data, I need to have a script that randomly select 15 records. But I don't even know how to use all the script functions. Please help me.

[danjacoby]

Here's how I'd do it; there are alternatives:

First, create a global field that returns a number ("gField").

Now, create a second global number field ("gCount")

Now, in the script:

Show All Records

SetField (gCount, 0)

Loop

SetField (gField, Round(Random * (Status(CurrentFoundCount) + 0.5)), 0)

GoToRecord/Request/Page "gField"]

... that is, by Field Value, and then select the gField

Omit Record

SetField (gCount, gCount + 1)

ExitLoopIf (gCount = 15)

End Loop

Show Omitted

[youkn0wwho]

Thank you very much. But do I have to have two fields set global? Cuz most of my fields need to be in text form.