Cécile

cfield=field1 OR cfield=field0 (modifier value in unrelated table)

Discussion created by Cécile on Oct 22, 2018
Latest reply on Oct 22, 2018 by philmodjunk
Branched from an earlier discussion

TABLES:   CLIENTS    PRODUCTS   ESTIMATE_LINES   CONTACTS   CONTACTS_INFO, etc.

Some of these tables are related to each other. The main actors of this problem will be 2 unrelated tables:  CLIENTS and PRODUCTS

 

In almost every table of the file, certain fields contain data that needs to be displayed or printed in English or French. I have triplicated those fields so that during Exports and Imports, only  the numbered versions will be updated (one contains French text, the other English text) along with the other "normal" fields.

example:

Country (calculation, output is text)

Country1 (text)

Country0 (text)

gCurrentClientDisplayLanguage

 

the calculation for Country (calculation field), the others are indexed,  is :

Let ([

      f=GetFieldName ( Self );

      fl= f & gCurrentClientDisplayLanguage];

      GetField ( fl )

    )

Where I am a unsure is how to get the value of the following unrelated table fields   client::Langue OR parameters::userFavLang  (for when the user is browsing products but there is currently no client that has the focus in the found set) so I can put it in gCurrentClientDisplayLanguage

Outcomes