Adding fields from another module in My Assistant

The query "Contracts not billed in X days" runs regularly and works great, but I would like to add in a few fields from JC (in our world, the CN contract number = the JC job number).  How can I do this?  When I pull the fields in, they display but all are blank.  Something is not working right. 

Parents Reply Children