AnsweredAssumed Answered

Value list showing one value but sorted by a different value

Question asked by richardsrussell on Jul 25, 2017
Latest reply on Jul 25, 2017 by philmodjunk

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?

Outcomes