Understanding Data Editing in Related Language Tables and Base Tables

When a user changes data on a language-sensitive page, the system responds by changing the contents of the base table, the related language table, or both, depending on the language of the user and which field was modified. The following table explains at the database table level the actions that are performed when you work with language-sensitive tables:

Action	Sign-in Language	Result
Translate a language-sensitive field. (The base language field has never been translated.)	Non-base	Adds a new row to the related language table that is keyed to the current sign-in language.
Edit a language-sensitive field.	Base	Changes a field in the base table without affecting the related language table.
Edit a language-sensitive field.	Non-base	Changes a field in a row of the related language table that is keyed to the current sign-in language. Doesn’t affect the base table.
Edit a non-language-sensitive field.	Base	Changes a field in the base table without affecting the related language table.
Edit a non-language-sensitive field.	Non-base	Changes a field in the base table without affecting the related language table. As the related language table contains only language-sensitive fields, no changes to this table are necessary.
Add a row (new key).	Base	Adds a new row to the base table without changing the related language table.
Add a row (new key).	Non-base	Adds a new row to the base table and a new row, keyed to the current sign-in language, to the related language table. This could introduce non-base language descriptions into the base language table.
Insert a row (effective-dated).	Base	Adds a new effective-dated row to both the base table and related language table. Add a new effective-dated rows to the related language table for each language for which translations exist for the object. Any updates to language-sensitive fields are applied only to the base table.
Insert a row (effective-dated).	Non-base	Adds a new effective-dated row to both the base table and the related language table for all languages for which translations exist for the object. Any updates to language-sensitive fields are applied to the current language in the related language table and to the base table.
Delete a row.	Base or non-base	Deletes the base table row and all dependent rows in the related language table.