AnsweredAssumed Answered

Dedicated Table for Value Lists

Question asked by johnhorner on Nov 12, 2011
Latest reply on Nov 15, 2011 by johnhorner

Title

Dedicated Table for Value Lists

Post

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:

main number

cell

fax

-

studio

home

 

i get instead:

_________________

cell

fax

home

main number

studio

 

is there anyway to preserve the original order when using field contents for a value list (besides numbering them)?  please advise.  thanks!

Outcomes