Dedicated Table for Value Lists
I have a solution that ustilizes many custom value lists. this works fine except that i have shared this solution with a friend of mine and everytime i need to update their solution with whatever current version i am working on, i loose any changes they have made to their custom value lists and they get my default value lists. i was going to dedicate a table with a single record and text fields to store these value lists so that their changes would be imported along with the rest of their data. however, i noticed that when i do this it always seems to display the field contents used to generate the value lists in alphabetical order, and not the order in which they are entered into their respective fields. this also means that i cannot create "groups" using the "-" character. for example, if my field contains:
i get instead:
is there anyway to preserve the original order when using field contents for a value list (besides numbering them)? please advise. thanks!