Multiple language fields

[macx]

I cannot get my head around a particular problem but I am sure there is an easy solution.

Can someone help or knock up a small database I can download and look at?

Here is an example of what I am trying to achieve.

3 fields, 1 spanish, 1 french, 1 english

They each have value lists assigned to them containing the numbers written in each language, so the English field would have 'one', 'two' and 'three' as its values, if I select 'one' as the value for the English field I want uno & un to appear in the Spanish and French fields, alternatively if I select an entry in another language I want the corresponding entry in the other language fields to be displayed.

I'm not using numbers but it helps to relay my quandary, I want the unused language fields to display the corresponding entry from its own value list.

The particular layout will be used by different language speakers and then re visited by say another language speaker so everything needs to be 'translated' as it were, on the fly as data is entered.

Anyone?

[comment]

See if this helps.

---

tag: languages

Languages.fp7.zip

[macx]

As simple as that. Thank you very much for your help 'comment'.

[El_Pablo]

hi,

I'm having the same problem. I check your solution, it works great for very small apps, but in bigger solution, this method would bring some management concerns.

Let say there are 10 different languages. Would you add 10 fields for each tables that are used value list?

What would be a good solution in this case?

Thanks

[hannie]

Hi everyone, newbie here....

I have a similar problem, just that I need multi language on text labels (for report layout). I have downloaded the example given here but this is multi language on the text/data itself. What I mean is like:

I have...

Name: Smith

Country: Italy

I need...

Nome: Smith

Paese: Italy

Is there a way for me to reference the layout labels programmatically/ via scripting and have it replaced with some values from my Language table? Any help would be much appreciated. Thanks!

[comment]

See if this helps:

http://fmforums.com/forum/showtopic.php?tid/183314/

[hannie]

Great! Thanks a lot for this. :)