We currently use the inspection workflow that esri recommends, i.e. we publish related tables for different layers and complete inspections on those layers in ArcGIS Field Maps. This works extremely well for our field crews but I'm running into some limitations when trying to generate reports on the inspections completed this way, specifically when trying to pull related records (the asset ID field from the main layer).
I'm wondering which tool I should be using to create reports on our layers that have inspections existing in related tables. I can generate reports on the inspection tables in ArcGIS Pro but can't seem to access any related attributes from the main layer.
Any advice is greatly appreciated.
