Looking up other tables

rbuser

I am making a report based on a Detail Table sorting by Product_Code.

The Product_Code decription is on the Master Table
Also on The Master Table is the Supplier_Code, the Supplier_Name is in a
seperately related Supplier Table

I am grouping the details where I want to Print The Product_Description
(from the Master Table) and the Supplier_Name(from the Supplier Table)

I have created the Product_Code link between the Master/Detail table but
when I preview/print I only see the description for the first item in
the Master table for all items the report.

All I want to do is look up the description for the grouped Product_Code
I am displaying. If I am doing this correctly why am I getting this
result or have I gone about it incorrectly or is there an easier way
altogether

rbuser

Dataman wrote:
Sorted it, it was a corrupt data table not displaying properly.