I have programming background - DEC Basic and understand how the databases function, just don't have much experience in actually creating databases in ACCESS.
My godson owns a retail store and he keeps track of games that are played in the store by people that compete in tournaments. I have offered to help him create a database with access where he can store the wins and looses of each player and sometimes the players will be the same and sometimes new players.
My challenge:
I have created a PLAYERS table. Simple, first and last names of players. Then a table which lists the fields of a WIN PLAYER, LOOSE PLAYER, WIN POINTS AND LOOSE POINTS AND DATE of GAME as fields. What I want to do is make sure that when he enters into the form for the win/loose data that he can select a player (that has been entered into the database for PLAYERS) which he can do but when he actually enters the statistics of the player as to whether he won or lost I want him to be able to have a drop down box with the players names from the PLAYERS table come up. This way he will select a pre-entered player from the drop down box. I have created the relationship but when I test the form and click on the drop down menu no names come up from the PLAYERS table. I wanted him to HAVE TO select from a list of players this way when he enters the player statistics only ones that are in the PLAYERS table will be available. If one is not then he has to use the PLAYERS form to enter the new player and then he can go to the STATISTICS table and enter the results of the tournament. Which will also prevent him from entering an existing name in several different ways. So if there is a name like "SAM SMITH" in the PLAYERS table and he goes to enter his stats in the STATS table he does not just type in "S SMITH" instead of the actual name. This way when I create the report for the statistics and it sorts by PLAYER'S NAME you won't have several different versions of the same player. I just can't get the players to come up in the field for players in the stats field form.
I hope I have explained this okay.
Thanks for your help
Mark
My godson owns a retail store and he keeps track of games that are played in the store by people that compete in tournaments. I have offered to help him create a database with access where he can store the wins and looses of each player and sometimes the players will be the same and sometimes new players.
My challenge:
I have created a PLAYERS table. Simple, first and last names of players. Then a table which lists the fields of a WIN PLAYER, LOOSE PLAYER, WIN POINTS AND LOOSE POINTS AND DATE of GAME as fields. What I want to do is make sure that when he enters into the form for the win/loose data that he can select a player (that has been entered into the database for PLAYERS) which he can do but when he actually enters the statistics of the player as to whether he won or lost I want him to be able to have a drop down box with the players names from the PLAYERS table come up. This way he will select a pre-entered player from the drop down box. I have created the relationship but when I test the form and click on the drop down menu no names come up from the PLAYERS table. I wanted him to HAVE TO select from a list of players this way when he enters the player statistics only ones that are in the PLAYERS table will be available. If one is not then he has to use the PLAYERS form to enter the new player and then he can go to the STATISTICS table and enter the results of the tournament. Which will also prevent him from entering an existing name in several different ways. So if there is a name like "SAM SMITH" in the PLAYERS table and he goes to enter his stats in the STATS table he does not just type in "S SMITH" instead of the actual name. This way when I create the report for the statistics and it sorts by PLAYER'S NAME you won't have several different versions of the same player. I just can't get the players to come up in the field for players in the stats field form.
I hope I have explained this okay.
Thanks for your help
Mark