Forum Discussion
Advanced filter options from different source.
Greg_Deckler, No It's one EventID that can have many Areas related so a 1-N in the relationship between Event-Area.
Events has many others relationships with other tables, but just 1-1, only in this case of Area that the same EventID can happen in more than one Area.
Area has just this relation with Events.
farina_dj Can you make it bi-directional or no? That would solve the issue so that Areas can filter Events
Greg_Deckler , sorry I think I didn't understand before, The table Areas does filter the Events, yes.
If I do a regular relation between Events and Areas I does work, and the filter get like this:And it filters by Areas. If I select Zone 2 it shows me only events of the Zone 2.
But the problem is the events that happens in Zone 1 and Zone 2 are being counted twice. Which means that if I don't apply any filter, the number of events is wrong, because the relation with Areas brings a cartesian plane.
That's the why I tried to produce another table AreasConcatenated that groups the same EventID and concatenates the areas to have a 1-1 relation. So the row becomes EventID = "x1", Area = "Zone 1, Zone 2".
But then it brakes the filter, because it becomes:What I'm trying to reach is a filter that only shows one option for each Area, but in a way that doesn't duplicate the event records if I don't filter.