Ok this next question is going to take some explaining.

A table holds custom values for multiple other tables. These tables are linked as in the image. Now the two fields I have circled are also linked - the {User_Values.Text3} holds custom values for {Transactional_Detail.Job}



If I add the {User_Values.Text3} to my report its empty but I get the {Transactional_Detail.Job} entries fine.

Am I right in thinking there must be a "middle man" table which links these two tables together, and that's the only way the values can be joined?

Thanks

Edited by shabbaranks - 24 Oct 2013 at 10:44am