Multiple tables linked with subreporting

hi,

i have 3 tables:

Tables
ProductInfo
- ProductCode - PK
- ProductName

InventoryDeposit
- TraceNumber - PK
- Date

InventoryDeposititems
- TraceNumber -FK
- ProductCode - FK
- Quantity

The Report should display:
the Subreport items is the one underlined
ProductCode ProductName TraceNumber Date Quantity

i was able to display results for everything except the "InventoryDeposit.Date"

How am i going to make it display with these relationship??

Can you attach the report and datasource?

i'm using mysql as ny datasource.
anyway, thanks. i got it running.
i joined the table via sql queries.
then made use of subreports:thumb: