The main report has basic data such as name, address.

A subreport is added to GH1h.  It displays the fees received for that record.  A 2nd subreport is added to GH1i which displays the completion date of the inspection(s)  The subreports are linked based on a payment key.  

 

I need to just select those inspections that have not been completed and that completion date is coming in from the last subreport. 

 

The reason I needed the 2nd subreport was because when I tried to link the additional table I needed to the others used in the main report I rec'd an error -- unable to change the link type.  All I wanted to do was add an additional table but for some reason I was not able to thus the reason for the 2nd subreport.

 

Can this be accomplished???