Hi all,

I've come across the following problem which I need to solve, but can't find the answer...

I'm working on a database solution that has to be multi-lingual. Fields labels are pulled dynamically from another file by calculation, related by language indicator (e.g. NL).

This works like a charm, except when you go into find mode. All field labels are empty then. Is ther a way to solve this?

Hope the question is clear, let me know if not.

Kind regards and thanks for your help/attention.

Hein

Fields labels are pulled dynamically from another file by calculation, related by language indicator

What exactly is dynamic...Is it a relationship to a Languages File ? Or is it a calculation from records of Languages File.

I think you need globals here...Any way you could trigger a script that would set the globals in Languages according to the Languages chosen.

1 script per languages ?

>What exactly is dynamic...Is it a relationship to a Languages File ? Or is it a calculation from records of Languages File.

It's related to a language file by 1 field, the language indicator.

>I think you need globals here...Any way you could trigger a script that would set the globals in Languages according to the Languages chosen.

1 script per languages ?

I'm just trying to not put all the label fields in the base file aswell. This works like a dream, apart from the find mode.

regards

Why not set your text fields to be global repeating containers instead, stored in a Global File, not all the files.

Then use a calculation for any label (that would become container field) :

CASE(Languages = NL, GetRepetition(Globalfile::your global tab/label,1),Languages = US, GetRepetition(yGlobalFile::our global tab/label,2),...)).

OOps...sorry, this is still a calculation...I didn't checked that one but maybe :

Case(Languages = NL,CASE(Status(Mode) = 2, GetRepetition(Globalfile::your global tab/label,1),GetRepetition(Globalfile::your global tab/label,1), Case(Languages = US,CASE(Status(Mode) = 2, GetRepetition(yGlobalFile::our global tab/label,2),....)).

If not, I definitely think the scripted method would do it (all globals still being "hosted" into a Global File...