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
> 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
>> 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"
news:Zc9Oj.3242$1a4.1199@fe73.usenetserver.com...
> Kevin Audleman wrote:
>> On Apr 18, 9:09 am, Ron Lambert
>>> 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@news.wanadoo.nl>, "Ursus"
> "Michael Myett"
> news:Zc9Oj.3242$1a4.1199@fe73.usenetserver.com...
> > Kevin Audleman wrote:
> >> On Apr 18, 9:09 am, Ron Lambert
> >>> 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