Translating

[FMPNewbie]

I have a report that I need translated. The user sees everything in english and make their selection by checking several check boxes. If they want the report to be in spanish I want them to click on a checkbox and the report will print in Spanish. Does anyone know how I can have a user click on an english value in the check box and have the spanish translation show up on another report?

[SteveB]

I suggest the following, but somebody else may have a better solution. This will only work if you're dealing with a limited number of terms to be translated.

The fields on the Spanish layout have to be calculations (text) to do the translations. You'd have a text calculation that would translate values from a value list: SpanishField1= Case(English1= "Mr.", "Senior",English1="Mrs.", "Senora")

[FMPNewbie]

Yeah I have thoght of this but I was wondering if their was a more dynamic way of doing this. I did not want to hard code the translations. Do you know of a way to do this with the translations in another file?

[BobWeaver]

I would probably create a file of Spanish and English phrases. The file would have a key field, an English phrase field and a corresponding Spanish phrase field. Then, when the user selects something in the main file, (by selecting a corresponding key value), a relationship to this lookup file would select either the Spanish or English phrase. As to how it actually puts the data into the report will depend on how you have things set up. But, you could use calculation fields in your layouts with formulae, similar to what Steve suggested, like this:

Case( SelectedSpanish, LookupFile::SpanishPhrase, LookupFile::EnglishPhrase)