We work in property management. Our properties report incidents to the corporate office, and we'd like to report back to the properties on the incidents we have collected. Below is a diagram of the tables we have setup and the reporting we'd like to run. Is it possible to create a report which runs based off a distantly related table?
An equation would be something like (see diagram below):
Incident X, Y, & Z is related to Property A, and if Property A has Resource Z, then the report would return Incidents X, Y, & Z in its report. A report run for Resource Z to know the incidents at their Property A.