Tables connection not working

[HitcH]

Hi everyone

I have three different tables.

1) Document number and its value

2) Document number and customer

3) Customer and customer details

The three tables are linked:

I want to create a table with customer and value of the document numbers linked to those customer, but it is not working:

Any idea about how could I do that?

Thanks in advance

[parry2k]

@HitcH seems like we both are talking about different things now. Better to put some sample pbix file and share them using one drive/google drive. remove sensitive information before sharing.

[HitcH]

Up 😞

[HitcH]

There you go: https://wetransfer.com/downloads/7b417d510e5bc87a90028520cda5869620230906131034/f54e859f68a1144df2c2...

[parry2k]

@HitcH 

1) Document number and its value - let's call it Table1

2) Document number and customer - let's call it Table2

3) Customer and customer details - let's call it Table3

First relatinship - Table 1 will join with Table 2 on document number, with 1 to many relationship, 1 on Table 2 side and many on Table 1 side.

2nd relationship - Table 2 will join with Table 3 on customer number with 1 to many relationship, 1 on Table 3 side, and many on Table 2 side.

[HitcH]

The problem is that the one that you call "Table 2" (in my screenshot it's the "LPT Delivery") has many documents with the same number because they are related to the different products, so the relation has to be "many to 1" instead of "1 to many".

I need to have a sort of vlookup in which I could connect "many" document numbers to the customer

[parry2k]

@HitcH the screenshot you shared is not what I mentioned.

[HitcH]

Then I'm sorry but I couldn't understand your explanation, can you add some more details?

[parry2k]

@HitcH this is how it should work:

Document with Value will connect to document with customer on document number

document with customer will connect to customer on customer number

and now you can use customer from customer table and value from the value column

[HitcH]

But that is exactly what I did, and it is not working... 😞