Suggestion for best practice language mng.

Applications Forms
#1

Dear all,

I need to manage several tables using a “language_id” field for selecting right descriptions.
For istance TABLE 1 (3 fields):
id : 1
lang_id : IT
description: CASA
id : 2
lang_id : EN
description: HOME/HOUSE
id : 3
lang_id : FR
description: MASON

When I do the SC login using control_login form I have the Language toolbar box where to choose one of available language. Doing that all traslation derive from locales / languages are correct and all forms show labels, buttond etc in the language you selected.

I need to understand how can I have the information from this login selection and use this variable to filter data within my tables:
I.e.
SELECT id, description from TABLE 1 where language_id = {variable_login_language}.

I hope to have the variable info as international code i.e. IT, EN, ES, FR, BR .

Many thanks
Giovannino

#2

Re: Suggestion for best practice language mng.

Sorry I didnt understand very well,

Did you mean the Language section in Tools->Locales ?

You can edit the labels and messages to appear for each language you want.

#3

Re: Suggestion for best practice language mng.

No, I know very well Locales languages.

My request is about using database tables with different translation records for different languages.
You choose the record, for istance in a lookup, using language_id filter as where condition.