have the field(s) twice on the layout, once with the Spanish value list and one with the English one, and use hide when to show just the correct fields.
If only 2 languages are involved you could as well have layouts called Layout_EN and Layout_SP and go to the correct one.
But of course! Thank you.
If the values are stored in records of a table, you can use a conditional value list to pull up the set of values specified for the currently selected language option.
If you are new to conditional value lists, you can learn about them from this file:
This file comes with working examples as well as detailed descriptions on how to set them up.
Gracias, Phil. I will check the conditional out, do not remember working with it. I'll go for the advice that takes me the shortest to do.
I have applied this in a solution using a separate table with 4 fields.
1: Value list name
2: The local (language)
3: The data value to be used
4: The display value in the language
Each languages has as many records in the table as we have values. Making a related TO using the local field and the value list name from global fields creates a conditional value list.
This valuelist has been set up using 2 fields from related records and the option only show data from second field enabled. The first field is the data value, the second field is the localized value.
We use popup menus as they keep showing the second field value even after selection while our field is actually holding the data value. The fields have an OnEnter script trigger to set the global field with the Value list name to return only that value lists items. The local is already set since it is using for the interface in general.
The benefit of this technique is that the selected values change there display when the local is changed and reporting is easy since data is standardized no matter what language was used at input.
Multiple value lists can be created in the same table this way, just remember to setup each of them with the exact same data values and name for each language.
Gee, thanks. That's why I love FM, so many ways to do one task. Learning something new everyday. I will "chew" on your advise a bit more.
In this link you'll find a sample file that solves your problem. It's a multi-language solution.
Hope you'll find it useful.
Intersting, Ibrahim. Thank you, I am not familiar with SQL so I am behind and a bit lost on how to implement it on my solution.