Language-dependent references
If data groups with more than one
Primary key are referenced and values of a session variable are used in the
foreign key, then a reference can be implemented as language-dependent. This option is especially useful in connection while accessing
external data.
In the following example, a jeans collection will be managed. If a user switches the portal's language to English, then the colors of each model will be displayed in the correct language.
German language setting
English language setting
On the edit page
Color, a constant is entered in the field
Color, this constant has the same character string in every language for a color.
In the
Language drop-down list, the corresponding language abbreviation will be selected here. In
Color Title, the color that will also be shown in the table on the
Collection page will be entered in its corresponding languages.
The structure of the application consists of the data groups
Color and
Jeans, whereby the
Color data group contains two primary keys (
Color and
Language).
The
Color data group will be referenced by the
Jeans data group.
When adding this reference, you have the ability to assign foreign keys in the
Relationships dialog.
Highlight the
Language primary key and click on
Mark assignment.
The session variable
Language will be selected as the foreign key, from which, at any time, the language key of the current language setting of the portal can be read in Intrexx.
click on
Next here.
The
Color Title will be selected as the data field here. To apply these settings, click on
Finish.
On the
Jeans edit page, the drop-down list, which allows the color to be chosen, can now be created.
The entries in the drop-down list stem from the
Color Title reference field.
Here is the
Jeans edit page in the browser. The correct entries will be displayed in the drop-down list depending on whether the portal is set to English or German.
German language setting
English language setting