I need a little (Maybe a lot of) help. I’ll start by explaining what I’m working with.
I have 4 tables, three contain unique information and the third contains relationships
-User- -Species- -Breed- (Breed also contains a relationship to Species but it is not used to complete this query currently)
The goal is to be able to filter by both distance to an address and by Species or Breed.
I can filter by distance when displaying all Species and Breeds by searching the User table for distance to X but I can’t figure out how to add search or filtering criteria that will assess the user based on entries in the Pets table. This is the default state
I can filter by Species or Breeds by searching the Pets table and displaying the creator, but then I can’t filter by distance. These searches are conditional states on the main results repeating group.
I have tried structuring my data different ways and this is the closest I have gotten. I tried working with lists but I just can’t seem to wrap my head around creating and modifying them.
Here is a link to a copy of the app, Thanks in advance for any ideas or advise.