Fixtures

[SiGill]

Hi
I run a Pool league. I am looking to make a database that will help me create the fixtures.

Thing is we have 4 divisions and some pubs have 2 teams that play out of that pub that are in different divisons. What I want this database to do is make sure the 2 teams aren't drawn at home on the same night.

Can anyone help.

many Thanks

 

[The_Doc_Man]

Look up "League" and "Sports" in this forum. Expand the search to go back at least 2 years. This question is not new to the forum.

 

[statsman]

I have been using a package called Home or Away to do all of my League scheduling for the past several years.
Download the demo at:
http://www.cfbsoftware.com/homeaway/homeaway.aspx

It's not too complex or expensive. There is a trick however.
If you have Team A and Team B sharing a venue, they must be entered as first and second or third and fourth or fifth and sixth.
If Teams A and B are playing in different divisions, the same holds true. Team A would be entered first in North Division and Team B entered second in south Division.

Good luck and welcome to the wonderful world of sports scheduling where no one is ever satisfied.

 

[SiGill]

Thanks for coming back. I have looked through the other post but can't find anything where, if two teams share a venue.

Thanks Statsman too, but I need something put into Access that I can give someone to use, then once the fixtures are set scores can be added and then tables worked out, etc.

Can anyone help.