Multiple feilds

jimeee

New member
Local time
Today, 01:25
Joined
Sep 12, 2002
Messages
6
In a table I am designing, there is a videoID field and a program field. There can be any number of programs on a video, so how do I desgn the table? There are also an unlimited amount of descriptions about every program (descriptions field)

I really need the help. thanks in advance.

Jimee
 
You should have two tables, one for the videos and one for programs on the videos, that way you can interrogate the programs table to find a specific program and return the associated video.

If all this is new to you, do a search on normalisation on this forum and the web in general, there are some good examples out there, not least of all a sample somewhere on this forum by our very own Pat Hartman ;)

With regard to your descriptions, it depends if you are going to allow a 'free text' description suchas:

"The film is about a young boy who finds love with another whilst picking flowers in a backwater town somewhere near Idaho"

OR only allow strict classifications suchas:

Action
Comedy
Drama
Fiction
Sci-Fi

etc...


If you choose the prior you may leave the field within the video table,unless of course you wish to describe each program, then you should house the field in the program table.(if you are doing it this way, you will need to become proficient at LIKE queries for interrogation purposes)

If you choose the latter, then you will require an additional table to hold these values in a reference(lookup) table with an associated field in the video/program table as desired.

My suggestion would be to do both, hold a field in the video table titled 'genre' linked to the types and in the program table add a memo field for a free text description of the program specifically
 
Last edited:

Users who are viewing this thread

Back
Top Bottom