Football Fixture Lists

[cunnie76]

Can someone please please help?

I am trying to create 2 databases (1) One for a football league, and (2) One for a football 'Cup' competition.

My problem is this;

How can I automatically generate fixture lists.

Example; if there are 8 teams in the league - how can I get the computer to create a fixture list over 7 weeks automatically so that teams always play a different team each week?
(What happens if it is a league of 12 or 6?)

Also; for the 'Cup' competition I want the computer to automatically create a draw - example; There will be 8 mini leagues - the top 2 from each league will go through to the 'knockout stages' which the computer will create. - i.e. Winner Group A will play Runner Up C etc.

You could save my bacon!

Thanks,

Bob

Can someone please help?

 

[ColinEssex]

This thread is also under General, Forms and Modules

If you're going to answer this make sure you're not wasting time because someone has already answered it elsewhere

Col