Random number from value list?

[Matthew R White]

I have a table with the field Producer Number. This table has about 10 records each with a different producer number 1-10 and these numbers change daily. Some days it will have numbers 4, 5, 6, 7. Other days it will have 1, 2, 5, 6. Etc.

I'm trying find a way to to set a field when entering a layout to a random number within this field so when 4, 5, 6, 7 numbers are entered in the field a random number from that set will be selected and entered into the field.

Further, is there a way to use this field or value set from my table and enter these numbers sequentially?

Please let me know if I wasn't specific enough.

 

Thank you!

[comment]

12 minutes ago, Matthew R White said:

when 4, 5, 6, 7 numbers are entered in the field a random number from that set will be selected

If you define a value list based on the Producer Number field, you can use =

Let ( [
values = ValueListItems ( "" ; "ProducerNumbers" ) ; 
n = ValueCount ( values ) 
] ;   
GetValue ( values ; Int ( Random * n ) + 1 )
)

to select a random value from the value list.

 

21 minutes ago, Matthew R White said:

Further, is there a way to use this field or value set from my table and enter these numbers sequentially?

I don't understand this. If the values in the field change daily, then what constitutes a "sequence"?