How to relate a db? I am in troubles

[Etnadan]

Hi,

I have a multilanguage database where I collect film information. Is called FilmDB

I have another where I have the translation of names in different languages. This is NamesDB

My FILMDB has several fields with the international names of actors, directors and other talent. Also I have a "glossary" field with international words for film making such as "cast", or "slate" or "grip" and more

My NamesDB has an International names field (where names do not have acccents just plain english text) and several different teranslation in different languages and di9fferent encodings (including Japanese, Chinese, Russian, Swedish and so on).

Both database are in UTF16.

I tried to link the two using the field "int_name" which both DB share, and it's exactly the same.

This to allow to display a page say in French, or Japanese an so on.

I do this because (for example) actor Al Pacino might star in several films with different capacities (lead, director, producer) and as I add a new title where he is present, I'd like to autom automatically update the different translations of his name without pasting and searching the Names DB.

This because I have several hundred different names and it would be great to be able to update automatically.

thanks

[Ender]

I can't tell what your current structure is, but I would probably go with something like that shown in the attached ER Diagram.

A Name can have multiple Roles for a Movie. A Roll has multiple translations for its Part or Title.

Then the trick is making the interface use the correct translation based on the specified language. To do this, put a global "Language Choice" field in the Name-Role-Movie table, and relate to a second table occurence of the Role-Language table based on that Language Choice and Role.