I have a repeating field in which I want to store a list of randomly selected values from another repeating field.

I have the random calculation sussed but when I try to put the GetRepetition calulation in any repetition other than 1 it does not appear?!

script step is:

Set Field ["repeatingField1" -2, "GetRepetition(repeatingField2;(random calc)"]

quote:

---

Originally posted by Coops:

I have a repeating field in which I want to store a list of randomly selected values from another repeating field.

I have the random calculation sussed but when I try to put the GetRepetition calulation in any repetition other than 1 it does not appear?!

script step is:

Set Field ["repeatingField1" -2, "GetRepetition(repeatingField2;(random calc)"]

---

Boy, ohh boy. I am pretty sure that this will not work. Repeating fields are pretty limited in functionality and I'd bet that this will not work. Better to use a small file with one record for each repeat.

You can then use a variable relationship based on your random number.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

Aye, Aye Capt,

I was afraid that was the case, normally I would always favour rellies over reps!

The reason for pushing reps was that I am making a game for a small child and wanted to keep it as a single file to avoid it 'breaking'. Ho Hum back to the drawing board.

thanks