Create a table relationship that joins on the concatenation of two fields and autofills lookup value
How do I create a table relationship that joins on the concatenation of two fields in the MASTER and DETAILS tables, then autofills the lookup value in a field in the DETAILS table. (See attached fo...