J
jah008 via AccessMonster.com
Hi
I am trying to create an access database that automatically generates a
competition draw for a mini soccer league. I have all the information tables
set up.....i just need to automate some things.
*Tables are Hyphenated*
I have 'Players' who are associated with 'Teams' that play at specific
'Times' and on different 'Courts' ever week for a certain length of time.
I some how need to auto-generate a competition draw that selects teams to
play a different team each week. They also need to play at different times
each week and on different courts, and to play each team in the competition
before playing the same team a second time. Basically the database needs to
take into account the previous week when working out the draw.
I can run a query to enter all this info into a 'Draw' table. But i want to
be able to click a button....tell the database that i want the seaon to run
from this date to that date, every thursday night, on two courts, with 4 time
sessions....and the database auto-generate the draw.
Can anyone help? Somehow point me in the right direction.....
Thanks
Josh
I am trying to create an access database that automatically generates a
competition draw for a mini soccer league. I have all the information tables
set up.....i just need to automate some things.
*Tables are Hyphenated*
I have 'Players' who are associated with 'Teams' that play at specific
'Times' and on different 'Courts' ever week for a certain length of time.
I some how need to auto-generate a competition draw that selects teams to
play a different team each week. They also need to play at different times
each week and on different courts, and to play each team in the competition
before playing the same team a second time. Basically the database needs to
take into account the previous week when working out the draw.
I can run a query to enter all this info into a 'Draw' table. But i want to
be able to click a button....tell the database that i want the seaon to run
from this date to that date, every thursday night, on two courts, with 4 time
sessions....and the database auto-generate the draw.
Can anyone help? Somehow point me in the right direction.....
Thanks
Josh