Hi there Dhrati,

I'm not sure what you're up to, but anyway, you can join the ReportInstance and ReportBroadcast tables by the reportID column, and then you can join the ReportInstance table to the Person table via ReportInstance.IPRequestor = Person.IPPerson and then you can join the Person table to the IPRltShp table via Person.ipperson = IPRltShp.IPChild and then you can join IPRltShp to the Organisation table via IPRltShp.IPParent = Organisation.IPOrg

Hope that helps your report,

Dave