I have two tables.
The ITEM RECD table containing the fields -- recd_invoice_ no, invoice_date,part_no,qty.
The ITEM ISSUE table containing fields- issue_no, date, part_no,qty.
The two tables are related by the part_no field.
How do I print a stock book type report for each item individually with all the recd item details on left side and the issued item details on the right side? All the recd & issue details for all dates need to be there in the report.