Design table and relationship

[Gian]

Hi All,

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)
-----------------
Cost ID
UCI
Cost

How can I set up the table / relationship so that when I create the report
it will only show the unit data , 5 years of maintenance and unit cost . I
always get the duplicate of the Unit Table for each year of the Maintenance.

Thanks.

Gian