AnsweredAssumed Answered

Multiple field lookup

Question asked by MilutinPetrovic on Jun 18, 2013
Latest reply on Jun 19, 2013 by philmodjunk


Multiple field lookup


     Hello friends,

     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!