AnsweredAssumed Answered

Lookup not working, can't figure out why.

Question asked by JosephSchueller_1 on Dec 13, 2013
Latest reply on Dec 13, 2013 by JosephSchueller_1

Title

Lookup not working, can't figure out why.

Post

     Hello, thanks for checking out my post.

      

     Here's the setup:

     Table "Awards"                  Table "Roles 2" 

     PK_AwardID---------------<FK_AwardID

     TagParentAward---------<TagParentAward

      

     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?

      

     Thanks!

Outcomes