Possibly a LOOKUP question...
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).