Note: An 'Exception' is an award given to staff member(s) which relates to a time value taken off the days working time.  i.e. 444 minutes = 7 hours 24 minutes.

I have a Staff Table (StaffT) with a Team Table (TeamT), a Category Table (the category of exception i.e. 'ITIssue', 'Scheduled Offline' etc.  The Type Table (TypeT) is a subcategory i.e. Network down, Wellbeing event etc.  The linking table is the Exception Table (ExceptionT)

I can currently award these Exceptions individually, but I want to be able to make awards to groups of people, i.e. 20 specific members of a Team.

What is the best way to go about this.  I have wracked my brains for ages but can't get my head around this.