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:
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?