Duplicate parent table

[Gian]

Hi All,

I try to create the report for each unit. if I use the Unit Table and Unit
Maintenance only to create the report, it works fine. But If I include the
Unit Cost, It will gave me the duplicate of the Unit Table for each year of
the Maintenance. Can anyone tell me how to fix the problem.

Thanks.

Gian

I have the following 3 tables:

Unit Table
------------

Unit Number (Primary key)
Unit Name
Unit Maintenance Index (UMI)
Unit Cost Index (UCI)

Unit Maintenance Table (EACH UNIT has 5 years of data)
---------------------------
Maintenance ID
UMI
Year
Number of Week

Unit Cost Table (EACH UNIT has 1 cost data)