The table SMEAL contains the meals served to the passengers during a flight. The table SMEALT maintains the meal descriptions.

The table SMEALT is the text table for table SMEAL. The key of SMEALT consists of the key of SMEAL and an additional language key field (a field with data type LANG).

Table SMEALT can contain explanatory text in several languages for each key entry of SMEAL.

To link the key entries with the text, the text table SMEALT must be linked with the table SMEAL using a foreign key. This is done by selecting the Key fields of a text table checkbox for the type of the foreign key fields.

The foreign key relationship is defined from SMEALT to SMEAL.

For each table, you can define one foreign key of type ‘text table’ only. This means that each table can have a maximum of one text table assigned to it.