Make new column from 3 linked tables

[Anonymous]

Hi all,

I am trying to make a new column from a couple of linked tables.

First table:

Partner A	Rev A
Partner B	Rev B
Partner C	Rev C

Second Table: 

Partner A	Vendor A
Partner A	Vendor B
Partner B	Vendor B
Partner C	Vendor C

Third table: (where C>B>A)

Vendor A	1
Vendor B	2
Vendor C	3

I want to add a column to the table with unique partner table (first table) with the max % from the 3rd table based on what vendors they have in table 2. How would I do this?

Resultant table

Partner A	Rev A	2
Partner B	Rev B	2
Partner C	Rev C	3

[lbendlin]

Not a good data model

Not sure how to get from here to your expected outcome.  Please elaborate.