Structuring a DVD Library

[JamesJoey]

I have DVDs of television series I'm trying to find the best way to structure them. For Instance:
I have several seasons of Start Trek: The Next Generation.
Each season has six to seven discs.
Each disc has four episodes.

I'd like to break this down into discs and a description of each episode.
Currently I have the season as the main title and a memo field with disc numbers and each episode on the disc.
I do searches on the memo field but run into issues.

Any suggestions will be appreciated,
James

 

[jwhite]

tblSeries
tblSeriesSeasons
tblSeriesDiscs
tblSeriesDiscEpisodes

 

[plog]

Just to explain jwhite's process---

He identified every object in your description and made it a table. The next step in that process is to identify every attribute of an object (series name, episode air date, type of disc, episode length, etc.) and create a field in the appropriate table for it.

After that, you build your database, throw in some fake data and see if you are able to get out of it what you want. If not, refine your table/field structures.

 

[JamesJoey]

I created all four tables and each has an ID field.
tblSeriesSeries a field named Series
tblSeriesSeason has SeriesSesonNumber
tblSeriesDiscs has a field called SeriesDiscs
tblSeriesDiscEpisodes has 2 fileds: SeriesDiscEpisodes and SeriesDiscEpisodeDesc (the discriprion of the episode.

I added the Series, Season, Disc, and Episodes on that disc.

This was done in each table separately.
How might I create a form so all information is explosed?

 

[plog]

You wouldn't create a form to show all the data at once. That is more the job of a report.

Are you certain your tables are properly structured and have all the fields in the appropriate places? I suggest reading up on normalization (https://en.wikipedia.org/wiki/Database_normalization) then once you have the tables down head over to http://www.w3schools.com/sql/ for a crash course in writing queries.

 

[JamesJoey]

Seems like a lot to fathom.