July 3, 200421 yr 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?
July 6, 200421 yr 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.
Create an account or sign in to comment