I'm in need of a way to choose a random record from a file. The way I
have it set up is that I need to select a random record from a external
file if a button is pushed. I have a file made up of 120 possible
tasks (records). In a related file I need the option to pick a random
task(record) from that file and display it in the related file. Any
suggestions
--
A second cup of coffee always works for me

On Apr 18, 9:09 am, Ron Lambert <rail... [at] sasktel.net> wrote:
> I'm in need of a way to choose a random record from a file. The way I
> have it set up is that I need to select a random record from a external
> file if a button is pushed. I have a file made up of 120 possible
> tasks (records). In a related file I need the option to pick a random
> task(record) from that file and display it in the related file. Any
> suggestions
> --
> A second cup of coffee always works for me

Go to Record [ Floor(Random * 120)]

Kevin Audleman wrote:
> On Apr 18, 9:09 am, Ron Lambert <rail... [at] sasktel.net> wrote:
>> I'm in need of a way to choose a random record from a file. The way I
>> have it set up is that I need to select a random record from a external
>> file if a button is pushed. I have a file made up of 120 possible
>> tasks (records). In a related file I need the option to pick a random
>> task(record) from that file and display it in the related file. Any
>> suggestions
>> --
>> A second cup of coffee always works for me
>
> Go to Record [ Floor(Random * 120)]

I would try Go to Record [ Floor(Random * 120)+1] to get the correct
range (1-120).

Mike M

"Michael Myett" <noone [at] nowhere.net> schreef in bericht
news:Zc9Oj.3242$1a4.1199 [at] fe73.usenetserver.com...
> Kevin Audleman wrote:
>> On Apr 18, 9:09 am, Ron Lambert <rail... [at] sasktel.net> wrote:
>>> I'm in need of a way to choose a random record from a file. The way I
>>> have it set up is that I need to select a random record from a external
>>> file if a button is pushed. I have a file made up of 120 possible
>>> tasks (records). In a related file I need the option to pick a random
>>> task(record) from that file and display it in the related file. Any
>>> suggestions
>>> --
>>> A second cup of coffee always works for me
>>
>> Go to Record [ Floor(Random * 120)]
>
> I would try Go to Record [ Floor(Random * 120)+1] to get the correct range
> (1-120).
>
> Mike M
>

And be aware that truly random not exists with filemaker

Keep well, Ursus

In article <480a016b$0$54873$dbd4f001 [at] news.wanadoo.nl>, "Ursus"
<ursus.kirk [at] orange.nl> wrote:

> "Michael Myett" <noone [at] nowhere.net> schreef in bericht
> news:Zc9Oj.3242$1a4.1199 [at] fe73.usenetserver.com...
> > Kevin Audleman wrote:
> >> On Apr 18, 9:09 am, Ron Lambert <rail... [at] sasktel.net> wrote:
> >>> I'm in need of a way to choose a random record from a file. The way I
> >>> have it set up is that I need to select a random record from a external
> >>> file if a button is pushed. I have a file made up of 120 possible
> >>> tasks (records). In a related file I need the option to pick a random
> >>> task(record) from that file and display it in the related file. Any
> >>> suggestions
> >>> --
> >>> A second cup of coffee always works for me
> >>
> >> Go to Record [ Floor(Random * 120)]
> >
> > I would try Go to Record [ Floor(Random * 120)+1] to get the correct range
> > (1-120).
> >
> > Mike M
> >
>
> And be aware that truly random not exists with filemaker

It's not reallt a FileMaker fault though - truly random numbers don't
exist on computers in any software.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

> And be aware that truly random not exists with filemaker
>
> Keep well, Ursus

Well it's certainly random enough.

Thanks, it would be random enough for me.
--
A second cup of coffee always works for me