You can add a table to the report more than once, so you could have pm_process.pm_id = im_incident_incident.im_child_id and pm_process1.pm_id = im_incident_incident.im_parent_id. Don't forget that you can also change the join type from an Inner Join to a Left, Right or Full Outer join depending on exactly what it is that you wish to report on.
Ah I didn't see that Lara had already replied and had already knocked up a little basic report for you to show how this can be done. Oh well I guess two replies is better than none! I left the table joins as equal so it will only show you incidents which have parent or child relationships.
ParentChild.rpt 50.0 K
Karen and Lara - thanks!
It was the join that was causing the issue. With the standard join only those Incidents that had a parent - child relationship were shown, as per Karen's demo report.
By changing the join to a left outer the child GUIDs appeared, whilst still reporting all of the records that had no parent - child relationship. I also found that I needed to join the additional pm_process1 table with a left outer join to the im_incident_incident table otherwise only the related records were shown again.
Once again thanks for the speedy response.