Tranlating Languages

  • Thread starter Thread starter Allie
  • Start date Start date
A

Allie

I have a problem that nobody seems to know the answer
to. I have two separate databases, one in English, one
in Spanish. The information is all the same, the only
difference in layout, design, etc is the data being in
different languages. I need to find a way to integrate
these into one to where if someone enters a record in the
English form, it is stored in the english table but also
gets translated to spanish and is viewable and editable
in the Spanish form as well. and vice versa. The data
that would need to be translated is entered in the form
of drop-down boxes. I don't have a background in doing
much with VB so I am limited in how complicated I get
with this!
 
Wow....what a challenge....:-)

One possibility: alter your tables to include a languageID field (1=english,
2 = spanish), and every form will have to add the LanguageID to the
underlying query.

So...if you have a table of colors:

tblColors:
ColorID
LanguageID
ColorName

(COlorID and languageID would make a composite primary key)

Sample data would look like:

1 1 Red
1 2 Rojo
2 1 Blue
2 2 Azul

etc.

The combobox on the form would be based on a select like:
Select ColorID, ColorName from tbColors where LanguageID = 1

results:

1 red
2 Blue

You would change the ID for the Spanish form.

For your lookup tables, this is going to double the amount of data, but not
for your "data" tables, since they will be storing a number.

Or, I could be completely nuts. I have not tested this...

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/Newsgroups
 
Back
Top