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.
