Football league management system

[fsagwe]

Dear Members,
Thank you very much for replying to my threads on the earlier posting.
Well,
I have created the following tables with equivalent queries:tblTeams, tblPlayers, tblReferees, tblFixtures, tblSeasons, tblVenues , tblTable Standings.With appropriate field names and relationships .
Help in:
a)SQL Statement/VBA Module code syntax in coming up and generating fixtures(home & away) on different game_Dates.For 20 teams

b)SQL Statement/VBA Module code syntax in generating different referees automatically

c)Is it possible to come with tables, forms, command buttons and VBA codes on a module and satisfy the equation above.

Kind Regards,

 

[GinaWhipp]

The only I see is you are missing a few Junction tables, i.e.

There will be many Players on one Team. To make that work you're going to need a Junction table...

tblTeamPlayers
tpID (PK)
tpTeamID (FK - relate to tblTeams)
tpPlayerID (FK - relate to tblPlayers)

So, I would suggest you work out all the Junction tables and then either post a sample file for us to review or post the names of the tables you created. Con't worry about the Forms, Reports, etc. right now, that Tables need to be right beofre we can move on to those things.

 

[fsagwe]

Thank you @ GinaWhipp for the sound advice .Actually am going to work on the tabless.Please do me another by giving me an overview on how to create junction tables in these case.Should I use SQL statements.Few guiding steps .

Dear Members,
Thank you very much for replying to my threads on the earlier posting.
Well,
I have created the following tables and equivalent queries:tblTeams, tblPlayers, tblReferees, tblFixtures, tblSeasons, tblVenues , tblTable Standings.With appropriate field names and relationships .
Help in:
a)SQL Statement/VBA Module code syntax in coming up and generating fixtures(home & away) on different game_Dates.For 20 teams

b)SQL Statement/VBA Module code syntax in generating different referees automatically

c)Is it possible to come with tables, forms, command buttons and VBA codes on a module and satisfy the equation above.

Kind Regards,

 

[GinaWhipp]

Junction tables are tables, no SQL involved. I printed an example in my first post. Hmm, perhaps I should better define. A Junction table allows for a many-to-many *relationship*, such as...

Many Players to one Team
tblTeamPlayers

Many Teams play many Games
tblTeamGames

Referees participate in many games
tblRefereeGames

Does that help?

 

[fsagwe]

Thanks, once more, let me try and make the tables first and I will update you on the progress.

 

[GinaWhipp]

And, I'll be here, sipping coffee, should you have any questions...