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 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