AnsweredAssumed Answered

How do you show many-to-many relationship field data in PDF

Question asked by Tony Lokey on Mar 15, 2018
Latest reply on Mar 15, 2018 by Patrick McQueen

We have a custom module where hardware configurations are stored that has a many-to-many relationship with another custom module that stores information about on-site service and installation. We want to be able to generate a pdf of the the onsite record that includes the serial number or numbers of the hardware pertaining to that visit.

We can create a pdf that has all the information from the service report  and any other modules that have a one-to-one or one-to-many relationship but can't add any information from modules with many-to-many relationships.

As an example, a technician may install 3 systems during a visit and those system are shown in a subpanel of the on-site service report. We would like the pdf of the service report to show the serial #'s for the 3 systems. Is there a way to accomplish this? 

We are using an on-demand version version 7.11. Thanks.