topic Re: Symbolize features based on related table in ArcGIS Mapping and Charting Questions https://community.esri.com/t5/arcgis-mapping-and-charting-questions/symbolize-features-based-on-related-table/m-p/295627#M948 <HTML><HEAD></HEAD><BODY><P>Join is your only option for symbolizing based on a field in a related table.&nbsp; The only other option is to join the related table and calculate the ID into a field stored on the target feature class so you can symbolize directly from the feature class.&nbsp; If the relationship is a one-to-many or many-to-many relationship then you could export the join to a new feature class to create a feature for each record in the related table.&nbsp; Symbology cannot be set up to use a relate.</P></BODY></HTML> Wed, 02 May 2018 14:26:08 GMT RichardFairhurst 2018-05-02T14:26:08Z Symbolize features based on related table https://community.esri.com/t5/arcgis-mapping-and-charting-questions/symbolize-features-based-on-related-table/m-p/295626#M947 <HTML><HEAD></HEAD><BODY><P>I have parcel layer and table of water meters, they are related. Now I want to symbolize parcels based on water meter&nbsp;district&nbsp;ID it is just two digits. I was able to do so by joining tables, but if there is any other way that will eliminate the need to use join and use just relate, I am using ArcMap 10.5?&nbsp;</P></BODY></HTML> Wed, 02 May 2018 13:11:34 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/symbolize-features-based-on-related-table/m-p/295626#M947 AnastassiyaSuprunova1 2018-05-02T13:11:34Z Re: Symbolize features based on related table https://community.esri.com/t5/arcgis-mapping-and-charting-questions/symbolize-features-based-on-related-table/m-p/295627#M948 <HTML><HEAD></HEAD><BODY><P>Join is your only option for symbolizing based on a field in a related table.&nbsp; The only other option is to join the related table and calculate the ID into a field stored on the target feature class so you can symbolize directly from the feature class.&nbsp; If the relationship is a one-to-many or many-to-many relationship then you could export the join to a new feature class to create a feature for each record in the related table.&nbsp; Symbology cannot be set up to use a relate.</P></BODY></HTML> Wed, 02 May 2018 14:26:08 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/symbolize-features-based-on-related-table/m-p/295627#M948 RichardFairhurst 2018-05-02T14:26:08Z Re: Symbolize features based on related table https://community.esri.com/t5/arcgis-mapping-and-charting-questions/symbolize-features-based-on-related-table/m-p/295628#M949 <HTML><HEAD></HEAD><BODY><P>See this thread:&nbsp;<A href="https://community.esri.com/thread/164994">https://community.esri.com/thread/164994</A>&nbsp;- this includes instructions on how to use definition queries to symbolize based on records in a related table</P></BODY></HTML> Thu, 14 Jun 2018 15:54:23 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/symbolize-features-based-on-related-table/m-p/295628#M949 MeganJohnson 2018-06-14T15:54:23Z