Subject Re: random From Eric Logan <jelogan@eltopia.com> Date Mon, 27 Jun 2016 16:53:46 -0700 Newsgroups dbase.getting-started Make it simple. Make a list of the 'rest of the golfers' Give each one a random number. Sort the list on the random numbers. Assign from the top down in sets of three or four to their groups. Won't matter too much how you do it because it's already randomized. E On 6/26/2016 5:53 AM, Charlie wrote: > Hi.. Could someone push me in the right direction? > > I have a database of say 40 golfers.  19 of those golfers are going to play in the upcoming tournament.  The 19 are selected so you have a filter with the 19 active golfers.  There are 5 golfers who are considered slow.  So I want to fit them in each group and possibly 2 at the end so play moves relatively smoothly. > > Then I would like to randomly place the rest of the golfers in a configuration of 3-somes and 4-somes with the 3-somes in the front of the group.  I'm not sure how to work this out in dbase.  I am writing this in oodml.  I have the database set up already. > > We have three tournaments a week and I want to make a schedule for each day, email each member that the tourney is scheduled and post the schedule to a web site in html.   I think I can figure this part out, but the order and grouping is not something I'm confident with. (or even have a clue!) > > Thanks for any help! >