Multiple field lookup
My problem is illustrated by an image bellow!
I have 2 tables, one containing some values, other containing the Spanish translation of the said values (its for a multi-lingual db). So, the way it is setup right now, when You select the value from the field "First" it will do a look-up and fill in appropriate value in Spanish language from the second table.
My problem is, how to do that exact same thing with the multiple fields in that same table. I tried the "Many-to-one" connection, but it failed, and I am out of ideas, so I would be grateful if someone could help!