Hello,
Table A is a dimensional table with a users list and Table B is a transactional table.
There is a relationship between the two with a lookup column (Table_A_FK).
In Table B, I'm able to lookup fields from Table A, by using the dot notation in the formula.
For example: UserName = Table_A_FK.UserName
However, I can't get the Email Address field.
Email = Table_A_FK.Email returns an error, although the Email field exists in Table A.
