pull downs for my database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a database for a collection of trading cards. I have
several brands i'd like to choose from in a pulldown menu rather than typing
in the brand for every entry. I'd like to be able to do the same thing with
the year the card came out, and the team the player is on, position of that
player and so on. can i do this with access or do i need to use something
else? and how can i make this happen????? gonna be typing for a year if
i can't get this question answered so please please help. Thanks a lot!!

-John
 
I am trying to create a database for a collection of trading cards. I have
several brands i'd like to choose from in a pulldown menu rather than typing
in the brand for every entry. I'd like to be able to do the same thing with
the year the card came out, and the team the player is on, position of that
player and so on. can i do this with access or do i need to use something
else? and how can i make this happen????? gonna be typing for a year if
i can't get this question answered so please please help. Thanks a lot!!

-John
Click to expand...

Very easy.

Create a Table in your databse named Brands. It should probably have just one
field, Brand. Fill it in with the names of all the brands that you need.

Do the same with a table Years, one Integer field CardYear (don't use Year,
it's a reserved word).

Then create a Form based on your cards table (you shouldn't enter data into
tables directly, they're very limited; use a form instead). Use the Toolbox
Combo Box Wizard to put two combo boxes ("dropdowns") on the form, one based
on Years, the other on Brands. Do likewise for the other fields.

John W. Vinson [MVP]
 
Back
Top