I'm looking for a solution to display picklists in multiple languages with SharePoint as a source.
The challenge is to be able to update list item in any language after item creation. Picklists and lookups are saving lookup values, if item was saved for example in French the next English editor will see it in French as the value is stored opposed to storing a key or ID as a foreign key and resolve it from lookup table later, during resolution we can pick any language if we need to.
Lookup lists are stored in separate lists as: key, lang, Description
Picklists are populated from lookup lists with filter based on language.
Can we include in populated picklists also keys, on selection save key only and on display resolve it against lookup lists? Same as we would normally do in relational databases? That might help us to use proper language during resolution.