Hi I have a report that shows the invoice id and the sale but it is duplicating both of these records. I am guessing it is a linking issue but not sure how to fix it, any ideas? i was thinking of surpressing the duplicate but that wouldn't work in the sale amount unless it could match the sale with the invoice id. The tables causing this are my invoice and order header tables. I've played with the links but I can't get it to stop duplicating.