I am trying to combine two tables into one for a project.

I have two tables (spanish and german). Each table consists of two fields term (english word) and translation (translated word in the respective language).

Instead of having the user go to two separate tables to perform a spanish and german word translation ([color:red]performing a find on the entered english word then display the translated term for that record[color:red]), I would like to combine the two tables into one (no problem with that) and using a layout among other things to make a selection via perhaps a toggle to determine whether I wanted the word to be translated into German or Spanish.

ie. "English to Spanish" "English to German" Then perform my find.

The single table would probably have a language key field of some sort in each record to distinguish between the two languages and the toggle would be tied to it somehow.

Thanks in advance for any help.

Why not just connect them via the english word in the relationship graph... That way if you have multiple german words that mean the same english word, or multiple spanish words that mean the same english word etc its not really an issue.

Edited March 2, 200718 yr by Guest