My query is regarding using 2 tables.

both tables have primary keys but when i pull out the 1 field (which is not one of the primary key) in the detail column report - it shows blank.

and it affect my other field - most of the columns now are incorrect detail.

 

How to use the field which is not a primary key in both tables so that the details will be correct?

 

Please help me.

Thanks,

Crist