label in different languages

[michele]

The database I have should display field labels in different languages (3).

As I don't want to work with different layouts (one per language) I'm looking for a (calculated?) solution.

Probably I will need a global that defines which language should be displayed. But then I'm a bit stuck.

I've seen a database that had calculations as labels but I don't remember how it worked.

Have you got a solution?

Thank you for reading and eventually answering this question.

[Logixx]

As you stated, you have to create global calcs for each label to display.

In my solutions, I create a preferences table where the user can choose his language (amid other things).

The 'label fields' are unstored global calcs based on the prefs.

To sophisticate a little bit, you may want to:

1/ add a custom language in the prefs table with a layout in which the user can translate each global and choose 'custom' as default

2/ link this with a user log in

However, to make this more basic, just add a global on each layout with a pop up menu displaying the language choices.

Don't forget to customize the alerts as well, which is really easy since v7 (though we don't know from your profile what version you are running).

Hope this helps.