Hi,
First Link the two tables...
then Select the Fields, OrderId, Date, Customer, ProductId, Qty, Price, Amount, etc...
Now Sort the details first via OrderId, then Date and then Customer...
Then In the Format Section of these three fields just have SUPPRESS IF DUPLICATED checked and you...