Perform find in function

[mcotton]

Hi everyone,

I would be happy if someone could help me with this tricky thing!

I have two different databases: MAIN and COMMON. The DB COMMON contains between other a table containing different string in different language:

Table DEFINITION, Fields are Name,French,English.

I've made a file reference for COMMON in MAIN and added the table DEFINITION in relationship so I can select the fields. From each layout of MAIN, I want to set the tooltips "on the fly", depending on the language and the object. So I need a function in SetTooltip that will retrieve the data stored in French (or whatever) where the Name='something'...

Does anybody have an idea?...

Thanx!

[John Mark Osborne]

Here is a file from my web site showing three methods to track multi-lingual tooltips.

http://www.filemakerpros.com/LocalizedTooltips.zip