Order in Value list

[David Holmberg]

I have a value list that is based on a repeating field. What I want is to get the values in the list in the same order as they are in the repeating field.

Rep 1 comes first in the list, then rep 2 and so on. I'd prefer only to have the values from the repeating field in the VL.

Is there a way?

[-Queue-]

If the value list is table-wide and not specifically related to a certain record or records, then specify the value list to also use a second field, which is a calculation field (or auto-enter calc) of Get(CalculationRepetitionNumber), and sort by it.

If it is a filtered value list by relationship, then you can't do it yet in version 7.