SalesHeader SalesDetails OrderHeader OrderDetails F1FANR F2FANR as F1FANR
KEORNR as OrderNumber1
KEORNR as OrderNumber2
KAORNR as OrderNumber1 F1FADT as Date F2FADT KELIJN as OrderLineNumber KAFACN F1MUNT F2ORNR as OrderNumber2 KECODE KAKNUM F1KNUM F2LIJN as OrderLineNumber KEAANT KACRED as Date F1FACN F2CODE KEPRIX KAMUNT F1VERT F2TFAK KEFIFO KAMULT F2BOEK KEFISC F2PRIX KEKOMS KEKITR
Can you share a image of how the table joins look?
Name AS,(Rename fields) then use them to link,Comment out and copy for backup in case something happens,
If u can mess with the source of this sheet...(If excel)then add something with the same name in each table as in:
FRONT then next table would be FRONT-2 etc....
U can use that to see how u will structure ur joins,its a lot simpler but different things work for different people,goodluck mate