Is there a way to have a selector populated with fields from a related table, that when one is selected, filters the related locations on a map?
I have a Dashboard I'm working on building for our county Vector Control guy. We have tick dragging locations on a map, and a related table of Drag Reports, where he enters the tick species that are captured at a drag.
He wants a filter on his dashboard that will
so like say I wanted only the drag sites that i caught Dermacentor variabilis, I could selected that specie and only the spots where that species has been found will pop up on the map
Seems to me that this should be possible with field mapping but I have not been able to get this.
I have it wired in the opposite direction, where selecting a map location filters a list of related reports, but I've not had success coming up with some combination of widgets that allows him to select a related table field to filter the map.
Any suggestions?
Thanks!