Football Fixture/Output System

[jimbohodge]

Hi,

I am trying to create an Access system for a 5 a-side football company. They have both League Fixtures and private bookings.
The aim of the system is to allow for input of new teams, referees and fixtures and also for private bookings.

Im really struggling with this one.
I have had a go at designing it in Access but the forms wont work.

I wanted the system to have the following fields:

TBL_Booking
Booking ID
Pitch Number
Date
Time
Fixture ID
Customer ID
(Only one of the last two fields will be filled in one being for a league fixture and one for a private booking)

TBL_Fixture
Fixture ID
Referee ID
Team1 ID
Team2 ID

TBL_Customer
Customer ID
Customer Name
Contact Number

TBL_Team
Team ID
Name
Manager ID

TBL_Manager
Manager ID
Name
Contatc Number

TBL_Referee
Referee ID
Name
Contact No.

Hope somebody can help.

Jim

 

[Lightwave]

Try this as a start...

http://www.access-programmers.co.uk/forums/showthread.php?t=105677

Something which I adapted from code within this forum. It is not perfect and I just made it up to help out with a small squash league that myself and a few friends started up.

Note that in it's present format it should allow you to get some kind of fixture list out (although you'll look like you're producing a squash league).

Note that the programming is pretty advanced as requires knowledge of combatitive mathematics which I am told is a final year maths course.

For your next trick you may want to start by unifying the laws of physics

M