Question question about relation in access

qupe

Registered User.
Local time
Today, 05:15
Joined
Feb 15, 2016
Messages
51
i have seen a lot of youtube videos about relation in access but still didn't under stand , i will explain the situation.
i am making a data base for watching TV series
so i create three tables

1- name
2-seson
3-episods

and the ideai is every series has many sesons and every seasno has many episods but always there is one episod for each series and season .
so i came with this reations but it does not work
1- i made id (primary key) in name table and connect it to series-id in seson table
2-i made id (primary key) in season table and connect it to series-id in episods table
3- i made relation from id (primary key) in name table to-episodes-id in
episode table

but it does not work
and always ask for enter parameter value for season and series


Plz help me thanks for all your help
 
I would skip the tSeason table. Put season info in the tEpisode table.
The show name table can relate to epi. All seasons can be gleaned from tEpisode.
 
I would skip the tSeason table. Put season info in the tEpisode table.
The show name table can relate to epi. All seasons can be gleaned from tEpisode.
but in this way if the series has season 5 how i could know what is the last episode i had watch
 
you would also have epi#
show, season, epi#, title
Xfiles, 5, 502, "The Truth"

most shows number their episode with 3 digit #s
 
let me explain the idea
i want to press the plus sign next to series to open seson and press plus sign next to season to open Episodes number .
the three table are :

1-series table
a-ID
b-Series name
c-Finished
d-Photo
e-Date

2-season table
a-id
b-series-id
c-season

3-Episodes table
a-series-id
b-season-id
c-last Ep Watched
d-Date

how to connect them for the way i described.


thanks for every one
 
Agree with Ran about not needing a Season table, just put it in Episode table. However, I will critique the structure you last posted.

1. What does Series.Finished really tell you? Family Guy was cancelled and brought back. X-Files was off the air for 20 years and is back. What do you expect this field to do for you?

2. What does Series.Date do? In the episodes table you will have the first and last date of every episode, so storing this field in the Series table doesn't make much sense.

3. Episodes.SeriesID is not necessary if you have a Season table. Again, think Season table is overkill, but if you have it, you don't store Series data in the Episode table.

4. Episodes.LastEpWatched is poorly named and conceived. It should simply named and thought of as Episodes.Watched. One record is not going to know if its the last one watched. To truly know that you have to query the entire table to find out. Plus, you can watch them out of order. So you should have a [Watched] field which is Yes/No to designate if you watched it.

That's the issues with your table structure. Now for how to set up your forms. You should have one form that lists every series, next to each is a button. You click that button and you are taken to a new form which lists that Series at the top and lists all the Seasons it has, next to each season is a button. Click that button and you are taken to a new form which lists all Episodes of that Season.
 
Agree with Ran about not needing a Season table, just put it in Episode table. However, I will critique the structure you last posted.

1. What does Series.Finished really tell you? Family Guy was cancelled and brought back. X-Files was off the air for 20 years and is back. What do you expect this field to do for you?

2. What does Series.Date do? In the episodes table you will have the first and last date of every episode, so storing this field in the Series table doesn't make much sense.

3. Episodes.SeriesID is not necessary if you have a Season table. Again, think Season table is overkill, but if you have it, you don't store Series data in the Episode table.

4. Episodes.LastEpWatched is poorly named and conceived. It should simply named and thought of as Episodes.Watched. One record is not going to know if its the last one watched. To truly know that you have to query the entire table to find out. Plus, you can watch them out of order. So you should have a [Watched] field which is Yes/No to designate if you watched it.

That's the issues with your table structure. Now for how to set up your forms. You should have one form that lists every series, next to each is a button. You click that button and you are taken to a new form which lists that Series at the top and lists all the Seasons it has, next to each season is a button. Click that button and you are taken to a new form which lists all Episodes of that Season.
let me answer your questions
1- finished filed give me the ability to sort finish series or anime .
2- date filed to know if a week had passed so i will know that a new episode has aired
3-i put series-id and season-id to identify each episodes record .
 
plz suggest any new order with same fields
 
plz suggest any new order with same fields
and as i descriped :
when i press plus sign wich coms from making relation bettween tables
in series table and seson table and it will look like this :D


+ | id || series name||.........etc.
+ | id || series id || seson |
| series id || seson id || epidos |.....etc.
 
qupe, it is good manners not to nag people to reply every 12 hours. It just irritates the people who may help you. Remember all the answers come from people who do it out of the goodness of their hearts.


From the bottom up your episode table should be linked to your season table and your season table linked to your series table.

Hope this helps
 
qupe, it is good manners not to nag people to reply every 12 hours. It just irritates the people who may help you. Remember all the answers come from people who do it out of the goodness of their hearts.


From the bottom up your episode table should be linked to your season table and your season table linked to your series table.

Hope this helps

so i do not need series-id in episodes table and change it with id with auto number in episodes table ???

i am sorry very much but for me as any one in this world who wants to do any project i want to end it fast although i know that can't be possible but i have to try

Again sorry
 

Users who are viewing this thread

Back
Top Bottom