topic Change symbology based on related table record SQL service definition? in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/change-symbology-based-on-related-table-record-sql/m-p/860978#M5696 <HTML><HEAD></HEAD><BODY><P>Has anyone had success trying to change the symbology of a point based on the presence of a related record? I have read that it is possible, that there is some SQL that you can put in the service definition before you publish the service. I just cannot figure out the correct SQL. This would be a great tool to show inspection reports have been completed on hydrants and manholes. If anyone could help I would appreciate it. Thanks</P></BODY></HTML> Wed, 26 Jul 2017 21:07:42 GMT Brian_Beyeler 2017-07-26T21:07:42Z Change symbology based on related table record SQL service definition? https://community.esri.com/t5/geodatabase-questions/change-symbology-based-on-related-table-record-sql/m-p/860978#M5696 <HTML><HEAD></HEAD><BODY><P>Has anyone had success trying to change the symbology of a point based on the presence of a related record? I have read that it is possible, that there is some SQL that you can put in the service definition before you publish the service. I just cannot figure out the correct SQL. This would be a great tool to show inspection reports have been completed on hydrants and manholes. If anyone could help I would appreciate it. Thanks</P></BODY></HTML> Wed, 26 Jul 2017 21:07:42 GMT https://community.esri.com/t5/geodatabase-questions/change-symbology-based-on-related-table-record-sql/m-p/860978#M5696 Brian_Beyeler 2017-07-26T21:07:42Z