I've created a survey for Park Inspections that uses Repeats to enable the inspector to take multiple photos of violations if necessary. So I have multiple questions, all with their own repeat for photos. So i have a lot of related tables, 24 to be exact. My issue is when I try to view the data on a map, i don't want to have to open every related table to see which one has a photo in it. Is there a way for me to query the related tables to only show the ones that have photos?
I'd be interested in hearing other approaches as well if my process is too cumbersome.