Table Design

[Yoavgold]

Hi there,

I'm trying to build a DB that will help getting info about movies and
theater plays.

I have tables for the Movies, Plays and Theatres data.

BUT

When I tried to define the time table for each movie it got messy, I don't
know what to do, how to define the time for each movie and play, almost
every movie shows in a different days and different hours – should I set a
table for each movie? Or maybe some more columns in the movie table…

How should I design the tables in order to manage each movie's time?

thanks

 

[John Vinson]

You need TWO tables in a one to many relationship - Movies and Showings. You
would use a Subform on the Movie form to enter showings; each record in
Showings would have a movie ID (a foreign key to Movies) and a date/time
field indicating when that particular showing is to happen. You might also
want to have a field for the theater in which it will be shown (if there are
multiple theaters).