extracting a random item from a value list - HOW?

[CobaltSky]

Hi Peter,

Do you know if there is a way to convert a repeating field into a value list

Yes. If you define a value list to use items from a repeating field, each repetition value will appear as a separate item on the list.

If you define the list to be conditional, all the repetition values on any record that matches the condition will be listed.

[Peter2543]

Thanks. I did try. IMHO this handles the original question of this thread, too, with very little infrastructural design.

I consider putting the repeating field and other DB parameters into the first record of the file, instead of into Admin, and make sure it does not get lost and seldom displayed. Maybe that's another thread in another subforum?

Peter