Registration of Players Database

[Chimp8471]

I am trying to design a database that stores information for a football (Soccer) League...

the purpose of this database is to log players registered in our leagues..

a player is required to fill out a form each season, this form has a reference number and players details on it..

a player is permitted to transfer between clubs twice within the season.

a player can only play for 1 team in any one season.

the trouble i am having is tracking the players movements...

i want to know which players have played in which competions throughout the season...

each team will complete the teamsheet, then send it to me. i want to then complete the form in my database, and for the database to update any records of who has played in which competition and for which club.


when a player transfers from one club to another i also need this to be recorded....

i hope this makes some kind of sense.

cheers

Andy

 

[Kraj]

Without spending too much time in the particulars of your database, here's what I think you should do:

To associate players with teams, create a new table using PlayerID, TeamSheetID and DateJoined.

To keep a record of player transfers, make another table with the same fields but make the date DateTransfered and use TeamSheetID in two fields - TransferedTo and TransferedFrom.

When you want to transfer a player, create a new form and query that changes the TeamSheetID and DateJoined in the original table and writes the appropriate data to the second table.

I don't know the rules of your league, but if there is ever a case where a team has more than 14 players at a given point, your current setup will not work and you need to do it this way.

 

[action]

Happy to help

Chimp, I noticed your post while killing time waiting for local Soccer Premier Results to be phoned in. I manage a number of databases for a number of different sports and manage about 500 teams so understand your issues. If you are still stuck then I may be could help. I looked at your database structure and have a few suggestions if you like. Private message me if you like.

Regards
Rob

 

[Chimp8471]

Hi Rob,

i tried to PM you but it says you couldn't accept them, so i have had to post in here

many thanks for you help, my access skills are very poor but i undertand that this is the best way forward...i have volunteered to take responsibility of the registrations in our local league and just want to try and make my life easier....

i have looked everywhere for a finished database that i could use, without any joy....

any help would be welcome

once again thanks

Andy

Chimp, I noticed your post while killing time waiting for local Soccer Premier Results to be phoned in. I manage a number of databases for a number of different sports and manage about 500 teams so understand your issues. If you are still stuck then I may be could help. I looked at your database structure and have a few suggestions if you like. Private message me if you like.

Regards
Rob

 

[Chimp8471]

right i have had a bit of a play with this and am not really getting to far...

i have attached my sample db for you to reference.

Problem number 1)

In my table

tbl_Registrations


you will see that

registrations for 1 & 2 are identical except for the registration number, a player is not able to be present at the same club with two registration numbers at the same time.
the only way the player could be linked to the club twice would be if he left to play for another club then returned

i need a way to stop this.

Any Suggestions please

also if there is anything wrong with my table layout or relationships i would love to hear your views

cheers

Andy

 

[Chimp8471]

hi,

i tried to address this problem some time ago, then swept it under the carpet, but now need to address this issue again.

i have a table called:

Tbl_Players

contains all player info

and Tbl_TeamPlayers

with team info

i have linked them very simply so that i can click on the teams and see which players are playing for who.

i now need to add a new table for players transfering from one club to another

the table needs to be able to store all the transfer details but then also move the player from one club to another in the other table that he is already in.

i need to be able to track the players previous club also.

i have added a table to store this info in, but have no idea how i am going to get this to work

please help

Andy

 

[Chimp8471]

Hi, i have been working on this project for months now and am getting nowhere very fast...

is there anyone that can please help me sort this out...

I have one week before i need to start logging this data, yet i am so lost...

i have got a db that i believe captures data of registered players, i now need to track which players are playing in which games....using the data from the teamsheets...

teamsheet picture is

as you can see there isnt that much dat athat i need to record....i just dont know how to link this little lot together...

i need to limit the number of players that are used on each team sheet to 14 players per side.

finally i recieve one form from each team for each game.

please can someone help me...i really am getting desperate now, i have attached my DB for anyone kind enough to be able to assit me

cheers

Andy