Actually the answer isn't simple. I've done a number of scheduling programs for athletics over the years, and they are real challenge.
If all the events are going to be at the same venue, you need two tables: one for leagues, one for matches Select the info from the matches, loop over the leagues, check to see if the league is already scheduled, if not schedule the first opponent each week that they have not already played. On Sat, Apr 16, 2011 at 3:13 PM, Jim Mixon <bigjim0...@yahoo.com> wrote: > > I have tried for many long hours and for the first time in a good long while > I am sorry to say I am about stumped . . . > > Hopefully some brains here can help me . . . > > I am trying to write a scheduling program for a client. It will create > pool(billiards) matches on a weekly basis . . > > I need to to be able to collect input from client and create the schedule > based on that input. > > 1. Number of weeks of session > 2. Number of teams in league > 3. This is based on a one day per week schedule > 4. Different matches created from week to week, without repeating combination > until they are possible combinations are used. Then repeat the pattern . . . > 5. One week home, next week away and back again . . > > I have tried numerous approaches, but I just never end up with all the > elements correct. Tried looping thru one list, looping thru two lists, etc . > . . > boy I could use some help on this one . . > > Got a feeling the answer is simple, but it just keeps getting away from me! > > > Anyone got time for this?? > > ;-') > jim > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343797 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
