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.
Country (calculation, output is text)
the calculation for Country (calculation field), the others are indexed, is :
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