Since as a newb I may be making things too complicated, assume I have this:
Table: Stores (state, locations (linked->locations:location)
“Alaska”, “Anchorage, Fairbanks, Nome”, …, …, …
“Arizona”, “Phoenix, Flagstaff”, …, …, …
Table: Locations (Location, state (linked->stores:state, … )
“Anchorage”, “Alaska”, … , … , …
“Fairbanks”, “Alaska”, …, …, …
“Nome”, “Alaska”, …, …, …
“Phoenix”, “Arizona”, …, … ,…
“Flagstaff”, “Arizona”, …, …, …
My table has a “linked field” for state, in the locations table, and locations, in the state table. In the state table, if you look at locations, it has the names of the towns. In the locations table, looking at “state” is linked to the state table. (Obviously, this is contrived. My actual table has other fields, but for all intents and purposes, this is the format.)
Given that, how do I use a filter, with link_row_has, to find out if “state” (in locations) has a specific value (like “Alaska” or “Arizona”)? And the vice versa, if I know a state, how do I query my locations table to only return those? (It’s not an equals, because the linked row seems to be a nested array.)
Hopefully that helps with what I’m asking. I apologize for not asking my question better, as I’m new to this and I don’t know the correct terms or really how to ask. I look forward to any insight on what I need to do to use filter to accomplish this.