I work in a law enforcement field and I'm trying to build a database to show crime series. On the top of the report, I want maps, title, and dates of the series which will have multiple related crimes. As a subform related by CID, I want the case number, dates, times, and other details of each individual crime. As a sub subform related by Case Number, I want details such as vehicle descriptions, suspect descriptions, items stolen, and other details. All the tables, forms, and query's have been built, but how do I put this all into a report?
I've attempted by making a crimes report with has the suspect, vehicle, and items queries embedded. I this drug this to the main report called series. This provided a "Cannot open any more tables" error.
Any advice is welcome....