Sorting records into groups
My database manages attendees at camp for teens. I need to breakdown all the attendees into groups of 7 or 8 and mix them up so there’s even distribution of boys and girls, a good mix of ages and ensure that people from the same places aren’t likely to be in the same group.
Is it possible to create a script, or some other type of sorting mechanism, that will create randomised lists based on this criteria? If so, how would I start constructing it – for example, what functions should I look into?