topic Re: How do I show only the latest related table entry on a Survey123 Report? in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/how-do-i-show-only-the-latest-related-table-entry/m-p/1096912#M37084 <P>Thanks for the response TL2. So would I apply this in the syntax on the form template?</P><P>Or as a filter on the related table in the web map?</P><P>Or I see there is a filter option within the Survey123 page when under the 'Data' tab?</P><P>Thanks,</P><P>Grant</P> Thu, 09 Sep 2021 19:30:20 GMT GrantHoward1 2021-09-09T19:30:20Z How do I show only the latest related table entry on a Survey123 Report? https://community.esri.com/t5/arcgis-survey123-questions/how-do-i-show-only-the-latest-related-table-entry/m-p/1096789#M37074 <P>I have a property inspection feature layer and a related table for the inspection details. Each time an inspection is performed I want to create a report, but I don't want the report to include details of every previous inspection done on the property; I just want to include the details from the latest inspection (related table entry).<BR />Thanks,<BR />Grant</P> Thu, 09 Sep 2021 15:09:23 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-do-i-show-only-the-latest-related-table-entry/m-p/1096789#M37074 GrantHoward1 2021-09-09T15:09:23Z Re: How do I show only the latest related table entry on a Survey123 Report? https://community.esri.com/t5/arcgis-survey123-questions/how-do-i-show-only-the-latest-related-table-entry/m-p/1096906#M37083 <P>date_field = (select max( date_field ) from table)</P> Thu, 09 Sep 2021 19:13:35 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-do-i-show-only-the-latest-related-table-entry/m-p/1096906#M37083 TL2 2021-09-09T19:13:35Z Re: How do I show only the latest related table entry on a Survey123 Report? https://community.esri.com/t5/arcgis-survey123-questions/how-do-i-show-only-the-latest-related-table-entry/m-p/1096912#M37084 <P>Thanks for the response TL2. So would I apply this in the syntax on the form template?</P><P>Or as a filter on the related table in the web map?</P><P>Or I see there is a filter option within the Survey123 page when under the 'Data' tab?</P><P>Thanks,</P><P>Grant</P> Thu, 09 Sep 2021 19:30:20 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-do-i-show-only-the-latest-related-table-entry/m-p/1096912#M37084 GrantHoward1 2021-09-09T19:30:20Z