I would like to create a view, which would list all the events of an organization (please look at the mockup). The problem is, that some of the are part of longer series, so I had to group them somehow. So now I have 2 content types (Event and Series of Events), the latter contains Field Collection field with multiple instances, which is used for sub-events. (Please see the scheme)
I use common date field for "Event" nodes and "Sub-event" field collection items, but I can't sort by it, because for "Sub-event" I would need to use relationship, which disables sorting of events.
So my question is: How would you create something like this?
I am using Drupal 7, Wiews 7.3 and latest version of Field Collection.
For better understanding of my problem, please look at following images (sorry, I can't post images because I'm new here):