relationships between table is needed

Hi all;

I have created relationships between 3 tables, the pivot table works only up to a certain point.

I have tab "Uniquesupplier" in which I have unique values.

Then I have linked the supplier table with the spend & contracts table. When I add in the pivot table the "contract ID" from the table contracts is asking me to create a relationship.

I do not understand what relationship I need to create.

Thanks

You need to define the contract # each invoice is associated with.

Hi;

I have thousand of invoice lines and contracts are associated to supplier ID. in the example attached in the case of cablegroup I have 4 contracts associated to the supplier ID and not to the invoice.

What relationship I can create so in the pivot table tab I can see: supplier ID - ERP Supplier - Spend - Contract ID - Proposed contract amount - contract expiration date

Thanks

If you cannot connect the invoice to the contract, you cannot include the contract number in your pivot, because there can be multiple contacts for each supplier. Therefore, Excel would not be able to determine which of the multiple contracts any given invoice is associated with. Check your transactional tables. There had to be a contract number associated with the invoice.