Hello everyone. I’m trying to create a small Access Database program that will automatically create a schedule of matches. What I have so far is a table with individual players. I would like the schedule to be created automatically once a button is pressed in a form. The schedule would be created once per season after a start and end date are entered. Also, the schedule could be in any random order, but each player will have to play every other player before a second match consisting of the same players is held.
What would be my first steps in creating this schedule?
Thanks in advance for the advice.