Video Library design question

J

Jason

I am attempting to create a video library database for our company. One field to enter is "PRODUCT", which I want to have a drop down box of all the programs we carry. I want the selection of one of these options to filter out options for another field. For example, if the program is "NBA BASKETBALL", how would I set up the database so that when you chose "NBA BASKETBALL" only NBA teams appear in a drop down box under the "AWAY" and "HOME" fields in the same database?
 
A

Allen Browne

See:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Jason said:
I am attempting to create a video library database for our company. One
Click to expand...
field to enter is "PRODUCT", which I want to have a drop down box of all the
programs we carry. I want the selection of one of these options to filter
out options for another field. For example, if the program is "NBA
BASKETBALL", how would I set up the database so that when you chose "NBA
BASKETBALL" only NBA teams appear in a drop down box under the "AWAY" and
"HOME" fields in the same database?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Designing an NBA database 4
Table Relationship Question 5
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
beautiful comfortable and timbelrand,nike shox,brand 0
Documents from shared model are created with design mode on 1
Design Questions 4
Basic database design - using tables to feed lookups 3
VBA Legacy Drop Down Not Working 0

Top