Hello all

I am after some advice, I am trying to do something better and wondered if you had any suggestions to make this years grouped event go a lot more smoothly behind the scenes.

Bit of background info: 
We run 16 Graduation events (Morning & Afternoon ceremony, Lunch and a Dinner).  Guests are invited to either some or all of these events and can bring a guest of their own.

Some of the issues last year:
Reporting was a nightmare - who is coming to multiple events?  I had to export this in the end and run a crosstab query in Access
Updating records - To register a constituent to multiple events was a long process and if they brought a non constituent guest they would have to be entered separately and then added to each event and linked to their invitee.

Surely if Raiser's gives a grouped event option there must be a simple way to enter this information, the wizard itself is clunky, repetitive and very un-user friendly, if the constituent has a guest (in reporting, this non constituent guest will display multiple times as they are seen as different guests (unless you add them manually into one event and then you can assign additional events to that guest - but also must again assign them to the invitee))

Would anyone be able to share some constructive advice or examples where they have been able to overcome this process.

Thank you very much

Michael

PS we are using TRE 7.85