Report field linking from 2nd table

[BDawg04]

This is probably a really simple question that I am just overlooking the answer to. However, I can't figure it out. My report is linked to a table (Complaint Register). One of the fields in this table links to another table (Product Line). They are linked by 'Product Code'. My problem is that on the report I want to display the 'Product Description' rather than the 'Poduct Code'. 'Product Description' is in the 'Product Line' table and I can't get it to display on the report. I've searched through the forum and have just gotten myself more confused. If anyone has some advice I would appreciate it.

 

[payback]

Create a query that links the two tables and outputs the fields you need, then use the query as the source for the report instead of the table.

 

[BDawg04]

The report already runs from a query. The query pulls 9 records at the moment. The field I need to display is in a third table. Whenever I try to add the third table to the query it shows no results when it is run. I am really confused as to why this happens. I thought this was going to be an easy task. I guess I'm making it harder than it is. Thanks for the help.

 

[payback]

The error is probably in the Joins of the query therefore resulting in no records. Right-Click on the join line and choose the required option e.g. all rows from Table A, or all rows from Table B, etc.