I return to you, Access Forums, in my time of need, because I have come far in my quest to improve our data handling, and have come upon a new frontier.
I am trying to generate a report that, for 5 chosen records, shows each of the related records and record data on the page. Each primary record should have its own page. Currently I have related master-child on RMA_nb, and the result is that I am shown a header with one RMA_nb, and then a detail section displaying one related record per RMA_nb. If I failed to explain this clearly, please ask any necessary questions and I will answer. These visuals may help:
All data table relationships:
RMA_nb primary query:
Subreport query:
Report design:
Report result: