I have 3 Table - 1. Sales line 2 Sales header 3. Purchase Header.
I would like to list all sales line data with some of the other 2 table field

I linked with sales line and sales header with a common field. In the third table I don't have any common field for all three but I have common field 2 and 3. When I link this 2 and 3 some records are duplicating. How to avoid this. please help. when I remove the third table data from the report its work fine. Please help

Have you tried to format the fields and check the box "Suppress if duplicated"?