Newbie Question

  • Thread starter Thread starter Agent_J
  • Start date Start date
A

Agent_J

I'm trying to create a table so that when you enter data, its a pul
down menu so you just select when you want instead of typing it. Fo
example, the Fields are Movie, Actor and Movie Genre and for Movi
Genre, you can then select Science Fiction, Action, Comedy, Romance
Horror, etc... which i typed in another table
 
Use forms with combo boxes. There is a wizard that makes adding combo boxes
quite painless.
 
Instead of one table with Movie, Actor, and Genre, you need three or more
seperate tables. You'd only want to enter "Elvis" once in the Actor table
then link the ID field for "Elvis" into each record that contains info about
a different Elvis movie. Let's say that a particular movie has two genres,
Adventure, and Romance. In that case you need a Movie-Genre table which
resolves many movies to many genres (and allows for multiple choices for the
same movie). You need parent:child forms to do this but the combo boxes and
wizards will work just fine after you setup your tables correctly.

Take a look at www.imdb.com which does what you're doing. You can create
the same functionality yourself, using Access.
 
Back
Top