Need help with Bowling League Database

[leaguebowler11]

I'm making database for my bowling league. I know how to make all the
necessary queries and the logic that goes along with it. What I'm trying to
do is to create a form that would let me enter data for each bowler. I've
already created a table with one field for team name and another field for
the bowler's name. Now I could just go into the table and fill in the scores
for each game, but what I would prefer to do is to create a form that has a
drop-down box from where I could choose the team name and after selecting the
team I wanted all of the players on that team would show up with 4 blank
boxes next to each name to fill in the scores of each game bowled and which
week the games took place. Thank you in advance for any all help you can
provide me.

 

[blgilbert]

Create a combobox and do something like this for the rowsource:
SELECT Distinct TeamName From tblBowlers

You'll obviously have to change the column and table names to how you
have them defined. The Distinct keyword ensures that each team name
only shows up once in the list.

By the way, a slightly better, more robust way to do this would be to
create a Teams table and to store the Id field from this table in the
Bowlers table. Then you'd use the teams table as the rowsource for the
combobox.

HTH

 

[leaguebowler11]

I didn't mention it, but its probably obvious, I wanted all the the
information that I would be entering to go into a table that I would base all
of my quereis off of. Thanks again

 

[mnature]

Could use a form/subform. Main form would have name of team and week played,
subform would have the bowlers on that team, and the field for their scores.

 

[leaguebowler11]

Thanks,
I tried what you said and I get a dropdown box with the names of the teams,
but once I select a team nothing happens. I want to be able to enter scores
and which week it is after selecting the team name I'd like the players for
that team to show up and have blank boxes for me to enter the scores for each
game and the week in which they were bowled.

 

[blgilbert]

You'll need another table to store scores, probaly with three fields:
Bowler, Date, Score
I agree with mnature: a form/subform where the subform is bound to the
Scores table. In the subform, have a combobox with bowlers names that
is restricted by the team selected in the parent form. The subform
should be a Continuous form to allow you to enter four records, one for
each team member.