We create text tables when we want to store explanatory text in several languages. It is not advisable to store such texts in your primary table. we can make a text table that must comprise the key of the primary table. Every text table must also have an additional language key field (field of data type LANG).

NOTE: You can create only one text table for each table. The system checks this when you attempt to activate a table with text foreign keys for the corresponding table.

Example: 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. Table A can contain explanatory text in several languages for each key entry of B.

Related questions