Best way to get random information from an unrelated table by calculation

[hartmut]

Hi

I have a table named "Information"

I have another table named "Quote"

I would like to bring in a random quote from the other table (Quote) into a field called "today" in the table "INformation"

I am always adding to the quotes so the number of records changes.

I would like to make a script to do this.

The problem is how to get this random from an unrelated table into the original table.

Just trying to find the best way to do this.

Thanks

dave

[Raybaudi]

Hi

it remembers me something...

http://fmforums.com/forum/showtopic.php?tid/192539/post/278075/#278075

BTW:

Go to Layout ["Quote"(Quote)]

Set Variable [ $quote; Value:GetNthRecord ( Quote::quote ; Ceiling ( Random* Get ( TotalRecordCount ) ) )]

Go to Layout [original layout]

Set Field [ Information::today; $quote]

Commit Records/Requests[]

[comment]

it remembers me something...

http://fmforums.com/forum/showtopic.php?tid/192539/post/278075/#278075

And also:

http://fmforums.com/forum/showtopic.php?tid/192607/

http://fmforums.com/forum/showtopic.php?tid/192149/

http://fmforums.com/forum/showtopic.php?tid/191993/

http://fmforums.com/forum/showtopic.php?tid/189073/

[Raybaudi]

And also:

http://fmforums.com/forum/showtopic.php?tid/192607/

Oh, a real "random" lover !

[LaRetta]

Either that or someone who isn't getting what is wanted and doesn't say so, so keeps posting about it!