AnsweredAssumed Answered

report on related records of more than one related table

Question asked by willem67 on Jun 8, 2014
Latest reply on Jun 8, 2014 by willem67

Title

report on related records of more than one related table

Post

     Maybe I am now asking the impossible, but I need to double check.

     My database has three tables:

         
  1.           paintings
  2.      
  3.           exhibitions
  4.      
  5.           documentations

     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?

Outcomes