Tbl1.name to tbl2.namecode

[jus_doc]

Im not real sure how to explain this problem

I need to run a qry for a report, but for one of the columns I need it to read something other than what it in the primary table. The main table will qry and output fine. But I need it to relate to a different table for the output

Tbl1.name needs to pull from tbl2.namecode

report should read: namecode not name.

 

[JHB]

Then include the tbl2 into the query and link it together with the tbl1 on the proper field(s).