Howdy all,
I'm an Access 97 novice, working on an access database to store hockey statistics.
I've created a form that allows me to enter generic data about the game: the date, the time, etc. Inside this form I've created a sub-form that allows me to enter player-specific information for that game: which player from which team scored, etc. Essentially, the sub-form captures all "actions" that occur during the game. Goals, assists, penalties, and "scratches."
In my sub-form, I have drop-downs for Team and Player Name. If you select team A, then only team A's players are visible in the Name drop-down.
The problem: let's say I have 5 "actions" in a given game. If I enter 3 goals for the "Sharks" and then one for the "Blazers", when I choose the team "Blazers", the team values in all of the other rows also change to "Blazers", when they should all be independent!
Does anyone have any ideas about this? Also, if you can give me any tips as to how I could better explain this issue, I'd appreciate it! I know it's not presented very well here.
Thanks a lot!
Steve Battisti
I'm an Access 97 novice, working on an access database to store hockey statistics.
I've created a form that allows me to enter generic data about the game: the date, the time, etc. Inside this form I've created a sub-form that allows me to enter player-specific information for that game: which player from which team scored, etc. Essentially, the sub-form captures all "actions" that occur during the game. Goals, assists, penalties, and "scratches."
In my sub-form, I have drop-downs for Team and Player Name. If you select team A, then only team A's players are visible in the Name drop-down.
The problem: let's say I have 5 "actions" in a given game. If I enter 3 goals for the "Sharks" and then one for the "Blazers", when I choose the team "Blazers", the team values in all of the other rows also change to "Blazers", when they should all be independent!
Does anyone have any ideas about this? Also, if you can give me any tips as to how I could better explain this issue, I'd appreciate it! I know it's not presented very well here.
Thanks a lot!
Steve Battisti
