Please feel free to let me know if you think this belongs in Views rather than here.
I'm creating an event calendar.
I have a content type called "Event" and a content type called "Library".
Libraries have locations.
Events have either a library (via an entity relationship) or a location of their own (some events don't happen at libraries).
I need to filter my View, which collects Events, by the event location (specifically by county).
In some cases, the location is coming from a field in the referenced Library, via a Views relationship.
In other cases, the location is a field in the Event itself.
I can filter either on the library location (via a relationship) or on the Event's own location, but I need both - I need the user to select a county and see all events in that county, whether they're at a library or not.
My problem is, I can't create a single exposed filter to operate on locations that may be coming from two different sources.
Do I need to somehow pull the library location into the Event, so that all Events have locations, whether or not they're at a library?