You are going to need some way to define the levels in your location hierarchy. In ours we have a custom field that defines the nature of the location and all it's children. Then we have a database package that can roll all descendant locations up to that those locations with the custom field populated either at all or for specific values. This allows us to tell you where an asset is in general, where a PM is, where work orders and to some extent Job Plans if they are used by PMs.
But it took a lot of work to do that for the full location hierarchy that we have. But it lets us summarize the data to the levels each group cares about. This data is on probably every 2nd or 3rd report.
------------------------------
Brad Delong
WDW
------------------------------