topic Re: Displaying Attributes & Related Records together in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/displaying-attributes-related-records-together/m-p/306252#M13311 <HTML><HEAD></HEAD><BODY><P>Have you looked into Arcade functionality to perform this task?</P><P></P><P><A _jive_internal="true" href="https://community.esri.com/community/gis/web-gis/arcgisonline/blog/2018/12/10/overlapping-features-in-pop-ups-quick-introduction-to-using-featuresets-with-arcade">https://community.esri.com/community/gis/web-gis/arcgisonline/blog/2018/12/10/overlapping-features-in-pop-ups-quick-introduction-to-using-featuresets-with-arcade</A></P></BODY></HTML> Mon, 29 Jul 2019 15:31:21 GMT MichaelVolz 2019-07-29T15:31:21Z Displaying Attributes & Related Records together https://community.esri.com/t5/arcgis-pro-questions/displaying-attributes-related-records-together/m-p/306251#M13310 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have been using Collector with our field crew for hydrant flushing among other things and have recently implemented related records in hopes of storing hydrant maintenance data. Yearly I need to report to multiple Towns on these maintenance aspects and I need to display them like I used to without related records as shown here:</P><P></P><P><IMG alt="" class="image-3 jive-image j-img-original" src="/legacyfs/online/454624_Hydrant flushing old.JPG" /></P><P></P><P>I can't seem to figure out how to get my identifying attributes from my layer (Hydrant ID, Town, Street) matched up and visible with the related records they hold (CL2 readings, gallons flushed, inspection date, etc.). I've tried working with the data in ArcPro, making the related records select upon hydrant layer selection. In a perfect world, i could view my Hydrant ID, location, and town (from Hydrant layer) as the first few attributes and then the related record inspection after it (lined up so I can tell how many gallons that hydrant flushed, etc) Right now the record doesn't show Hydrant ID or anything, just a GlobalID/Parentguid link.&nbsp;</P><P>Hydrant layer fields:</P><P><IMG alt="" class="image-1 jive-image j-img-original" src="/legacyfs/online/454622_Hydrant Fields.JPG" /></P><P>Hydrant inspection records:</P><P><IMG alt="" class="image-2 jive-image j-img-original" src="/legacyfs/online/454623_Inspection Fields.JPG" /></P><P></P><P>The only luck I've had so far is bringing the tables into excel and doing Power Query to merge the tables based on GlobalID/Parentguid in related record. This kind of works, but not if there are multiple records for one hydrant since there would be multiple GlobalID matches I believe (as shown in Inspection Fields image). It has been a pain to say the least.</P><P></P><P>Any ideas or suggestions would be much appreciated, thanks!</P></BODY></HTML> Mon, 29 Jul 2019 15:16:50 GMT https://community.esri.com/t5/arcgis-pro-questions/displaying-attributes-related-records-together/m-p/306251#M13310 BrendonJoyce1 2019-07-29T15:16:50Z Re: Displaying Attributes & Related Records together https://community.esri.com/t5/arcgis-pro-questions/displaying-attributes-related-records-together/m-p/306252#M13311 <HTML><HEAD></HEAD><BODY><P>Have you looked into Arcade functionality to perform this task?</P><P></P><P><A _jive_internal="true" href="https://community.esri.com/community/gis/web-gis/arcgisonline/blog/2018/12/10/overlapping-features-in-pop-ups-quick-introduction-to-using-featuresets-with-arcade">https://community.esri.com/community/gis/web-gis/arcgisonline/blog/2018/12/10/overlapping-features-in-pop-ups-quick-introduction-to-using-featuresets-with-arcade</A></P></BODY></HTML> Mon, 29 Jul 2019 15:31:21 GMT https://community.esri.com/t5/arcgis-pro-questions/displaying-attributes-related-records-together/m-p/306252#M13311 MichaelVolz 2019-07-29T15:31:21Z