4 Replies Latest reply on Jul 25, 2017 4:28 PM by philmodjunk

    Value list showing one value but sorted by a different value

    richardsrussell

      I am seeking to create a drop-down list of articles from different languages. And I want it to originate dynamically from a table of prefixes and suffixes. I'd like it to be displayed in a drop-down list in alphabetical order within each language, so far involving English, French, German, and Spanish, thus:

      A

      An

      The

      Des

      L'

      La

      Le

      Les

      Un

      Une

      Das

      Der

      Die

      Ein

      Eine

      El

      La

      Las

      Lo

      Los

      Un

      Una

      Unas

      Unos

       

      In the source table for this list, each of the above words is accompanied by the name of its respective language, and I'd like the drop-down list derived from that table to appear showing only the article but sorted by the combination of language name and word. Damned if I can figure out how to do this without being forced to display the 2nd value as well, which I would rather keep hidden from my users. Any ideas?