Table A is a text table of table B if the key of A comprises the key of B and an additional language key field (field of data type LANG). Table A therefore can contain explanatory text in several languages for each key entry of B. To link the key entries with the text, you must link text table A with table B using a foreign key. In this case you must select Key fields of a text table for the type of the foreign key fields.

If table B is the check table of a field, the existing key entries of table B are displayed as possible input values when F4 is pressed. The explanatory text is also displayed in the user’s logon language for each key value.

Only one text table can be created for table B! The system checks this when you attempt to activate a table with text foreign keys for B.