• Thanks c_o, for helping out.

    the SQL code works perfectly!!

    Do you know how to create a hierarchy group from the event_roles?

    Thanks again.