We have a dashboard with a map that shows beaches as polygons. The table includes beach name, beach owner, beach maintenance agency, and nonprofits cleaning the beach. There is a field for each beach nonprofit so that when a user clicks on the polygon, the popup shows the owner, maintaining agency, and all the nonprofits that clean the beach. That part works with the exception that it would be nice for fields that are blank to not show.
The dashboard also has three pulldown boxes at the top. For owner, you can click on the name of the owner, and the beaches that are owned will reveal themselves on the map. The same for the maintenance agencies. Those two are one-to-one relationships that work great. For. the nonprofits its a one beach to many nonprofit relationships. We want to be able to click on the name of a nonprofit and reveal the beaches they clean on the map and don't know how to do it. Can anyone help? Thanks.
