Translations of Buttons and Fieldnames

[Libremiki]

My application can be used in different languages. For the translation I have a table with the fields ID, English, German, French, Chinese. How to I get the button to display the text of example - ID 5, German? The language would be defined in the settings.

I try to avoid translating all the forms and make different language versions. It would be much faster just to translate a table into the new language.

Michael

[RobertG]

Hi Michael,

you could, by macro, set the Title for each control when starting the form. I would add the ID for the transaltion in the Tag (additional information in German translation). So when loading the form you could start the query for the label-fields, which should be translated. And you could set the values for every label, which is part of the rows you will get.

Haven't tested it yet.
------ Update: See the atttachment. You could change the language of the labels in the form from Englisch to German. ------

Robert

[Libremiki]

Thank you for the comment. I will try your approach with makros, it makes sense. At the moment I am working on the translation table. Have to play with makros as my experience here is rudimentary.
Michael