Relating Tables - Noobie Question

[Capt.Ragnar]

I've had success relating tables however I've attempted to create a table to compliment an existing table and draw the data in but the relationship fails.

If anyone could explain why I'd appreciate it. I posted an example of the two tables below. I am trying to relate them between the "FruitName" fields.


Table 1:

Unique ID	VendorNumber	VendorName	DeliverDay	Manger	FruitName	Address
1	Peter	Peter's Produce	Mon	Kevin	Lemons	1 A Street
2	Paul	Paul's Produce	Tue	Kevin	Watermellon	30 A Street
3	Mary	Mary's Produce	Tue	Kevie	Bananas	654 A Street

<TBODY>
</TBODY>

Table 2:

Benchmark ID	FruitName	Days Delivery	Shelf-Life	Days to Exp	Exp Percentage
1	Apples	5	25	20	.2
2	Bananas	6	15	9	.2
3	Oranges	5	32	27	.2
4	Plums	6	15	9	.2
5	Watermellon	5	25	20	.2
6	Lemons	5	19	14	.2

<TBODY>
</TBODY>

The pivot view I'm going for is:

Rows:
Manager (Table 1)
VendorNumber (Table 1)
FruitName (Table 1)

Values:
Sum of Days to Exp (Table 2)

All I get is a failed notice of the relationship I created between the "FruitName" fields in the Diagram View. The Values are the sum of the whole column not the sum of the value for each rows value.

Thanks in advance.