https://community.esri.com/t5/arcgis-dashboards-questions/query-records-in-a-related-table/m-p/1086896#M4921 <P>I have a published feature service with a related table. &nbsp;I can successfully query the feature and show the associated results in a related table but I can’t seem to figure out a way to query the related table then filter the associated feature. &nbsp;Is it possible to do a query on the related table?</P><P>Example: Feature contains salesperson location and id number. &nbsp;Each sales person could be assigned to multiple states as recorded in a related table. Selecting the sales person will filter and show me the states they are assigned to. &nbsp;However, each state can also have multiple sales persons assigned. I can’t figure out a way to select the state (from the related table) and have it filter to show the sales persons assigned. If I set it up as a category selector and use grouped value, since there are multiples of some states, I don't have the option to select the source field. It automatically selects the same field in the category selector, in this case state.</P><P>Thanks for the help!</P><P>&nbsp;</P> Sun, 08 Aug 2021 07:18:30 GMT JBLYON3 2021-08-08T07:18:30Z https://community.esri.com/t5/arcgis-dashboards-questions/query-records-in-a-related-table/m-p/1086896#M4921 <P>I have a published feature service with a related table. &nbsp;I can successfully query the feature and show the associated results in a related table but I can’t seem to figure out a way to query the related table then filter the associated feature. &nbsp;Is it possible to do a query on the related table?</P><P>Example: Feature contains salesperson location and id number. &nbsp;Each sales person could be assigned to multiple states as recorded in a related table. Selecting the sales person will filter and show me the states they are assigned to. &nbsp;However, each state can also have multiple sales persons assigned. I can’t figure out a way to select the state (from the related table) and have it filter to show the sales persons assigned. If I set it up as a category selector and use grouped value, since there are multiples of some states, I don't have the option to select the source field. It automatically selects the same field in the category selector, in this case state.</P><P>Thanks for the help!</P><P>&nbsp;</P> Sun, 08 Aug 2021 07:18:30 GMT https://community.esri.com/t5/arcgis-dashboards-questions/query-records-in-a-related-table/m-p/1086896#M4921 JBLYON3 2021-08-08T07:18:30Z