AnsweredAssumed Answered

Possibly a LOOKUP question...

Question asked by IgnacioRojo-Allamand on May 9, 2013
Latest reply on May 9, 2013 by philmodjunk

Title

Possibly a LOOKUP question...

Post

     Hi, I've got the following question for you guys. Hopefully you can help me.

     Having two Tables, let's call them "X" and "Y" and a table "X" associated to table X.

     Is it possible to fill automatically a field on the form X with some data on table Y if some fields in the form X match with the related fields on the table Y? Maybe a lookup?

     In the example (picture uploaded), the idea is fill the field "AAA" with the content of the field "RED" if the condition(s) "a" matches to the "α" (actually are many conditions on a one to one relationship).

     Thanks.

example.png

Outcomes