Use selected language to pull appropriate data into other fields... How?
Database with 200 clients, in three different languages. Intend to make a "Terms & Conditions sheet" with terms applicable to the client. Select appropriate language with radio button set in this Client table.
In related table "Terms_Conditions" there are various fields in three different languages, such as payment conditions in English, in German, etc.
Selecting for instance English (radio button) in Client table should pull the right translation, in other words: the contents of several other fields should then be in English.
Example: Customer John Doe -- English language --> trigger data in fields "Payment conditions" and "Validity of Terms" in English.
Client Fritz Schmidt -- German language --> trigger data in fields "Payment conditions" and "Validity of Terms" in German.
How to do this?
Thank you for your time and your patience.