I have a published feature service with a related table. 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. Is it possible to do a query on the related table?
Example: Feature contains salesperson location and id number. 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. 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.
Thanks for the help!