Pulling field from linked 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.

 

[llkhoutx]

Presumably ComplaintRegister and ProductLine linked in the record source of your report.

The controlSource of the field ProductCode should be ProductLine.ProductDescription, which can be selected from the droplist at the extreme right side of the the report's ProductCode textbox.