Forum Discussion
Helper IITables connection not working
Super User1) 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.
Helper IIThe 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