Related tables - two tables that won't relate

[sandi123]

Hi all,
I have two tables.

1 - contains project profitability data.
It contains the period end date and the project number and name with the relevant data against (many many rows)
The above three criteria will duplicate in the list as a new months information is pasted into the rawdata

2 - contains accounts receivable data
It contains the period end date and the project number and name with the relevant data against (many many rows)
The above three criteria will duplicate in the list as a new months information is pasted into the rawdata

Problem:
I can't link the tables uniquely as i get a duplicate error.
I have tried to create a 3rd table removing the duplicates in the project number and connect the two tables this way, however, they still won't appear as related.

Any help in the process to connect these two tables would be great.

Thanks,

 

[bobby_smith]

What should the desired results look like?

 

[sandi123]

Hi Bobby,
I need to take:
project name (which is also duplicated), date from the 1st table.
Invoice number and balance from the 2nd table
and put into one pivot table

Thanks