I'm stuck on the final report of a soon-to-be complete db. Data from the following tables needs to go on a single report: 'Table1', 'DocsReceivedRev', 'CaseNotes' and 'Meetings'. The 'CaseNo' field is in 'Table1', to which the remaining three fields have a one-to-many relationship.
When creating a report, the records from each of the other tables are repeated (about 6 times). I tried to create a query and then a report from the query but got a similar problem.
Any help would be highly appreciated.