Lookup not working, can't figure out why.
Hello, thanks for checking out my post.
Here's the setup:
Table "Awards" Table "Roles 2"
AwardID is the serial/key, of course, and TagParentAward is simply a calculation that results in "X" in either table based on certain criteria. It is calculated in each table, respectively.
The relationship should look up 3 fields in the Roles 2 table: PI_Email, DeptAdminEmail, and ContactEmail. It's only working for the PI_Email field, and I cannot, for the life of me, see why.
I've double and triple checked that the record match criteria are valid and present in all appropriate records. Basically, the look ups are identical, but only one of them is functioning. Any ideas?