View Single Post
  #1  
Old October 27th, 2009, 11:15 PM posted to microsoft.public.access.tablesdbdesign
Josh Davis
external usenet poster
 
Posts: 15
Default DVD Movie Database Question

I am creating a DVD Movie Database using the template on Microsoft Office's
Web Site. My question is this and please correct me if I am wrong. It seems
to me that if you have a DVD of a television series that also has seasons as
well as episode numbers-assuming that the person/place does not have all the
episodes, would you not need to set up a field for the "Seasons" & "Episode
#s"? Or even a table at least to store that info? You wouldn't logically put
the the TV series' name in the "DVD Programs" table's "Program Name" field
and add "Season 1 Episodes 1, 2, 3 , & 4," right? I am just really confused.