report on related records of more than one related table
Maybe I am now asking the impossible, but I need to double check.
My database has three tables:
With many-to-many relations records are linked.
For reports showing related records I use layouts of lists with details of record X in the header and details of related records in the main part. That works very good. E.g. painting X and all related exhibitions. Of report I make a PDF.
But, I would like to make one report of painting x and all related exhibitions and all related documentation. Then I can make one PDF instead of making two separate PDF's.
Any solutions I overlooked?