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:

[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD]Unique ID
[/TD]
[TD]VendorNumber
[/TD]
[TD]VendorName
[/TD]
[TD]DeliverDay
[/TD]
[TD]Manger
[/TD]
[TD]FruitName
[/TD]
[TD]Address
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Peter
[/TD]
[TD]Peter's Produce
[/TD]
[TD]Mon
[/TD]
[TD]Kevin
[/TD]
[TD]Lemons
[/TD]
[TD]1 A Street
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Paul
[/TD]
[TD]Paul's Produce
[/TD]
[TD]Tue
[/TD]
[TD]Kevin
[/TD]
[TD]Watermellon
[/TD]
[TD]30 A Street
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Mary
[/TD]
[TD]Mary's Produce
[/TD]
[TD]Tue
[/TD]
[TD]Kevie
[/TD]
[TD]Bananas
[/TD]
[TD]654 A Street
[/TD]
[/TR]
</TBODY>[/TABLE]

Table 2:

[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD]Benchmark ID
[/TD]
[TD]FruitName
[/TD]
[TD]Days Delivery
[/TD]
[TD]Shelf-Life
[/TD]
[TD]Days to Exp
[/TD]
[TD]Exp Percentage
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Apples
[/TD]
[TD]5
[/TD]
[TD]25
[/TD]
[TD]20
[/TD]
[TD].2
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Bananas
[/TD]
[TD]6
[/TD]
[TD]15
[/TD]
[TD]9
[/TD]
[TD].2
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Oranges
[/TD]
[TD]5
[/TD]
[TD]32
[/TD]
[TD]27
[/TD]
[TD].2
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Plums
[/TD]
[TD]6
[/TD]
[TD]15
[/TD]
[TD]9
[/TD]
[TD].2
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]Watermellon
[/TD]
[TD]5
[/TD]
[TD]25
[/TD]
[TD]20
[/TD]
[TD].2
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]Lemons
[/TD]
[TD]5
[/TD]
[TD]19
[/TD]
[TD]14
[/TD]
[TD].2
[/TD]
[/TR]
</TBODY>[/TABLE]


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.