many relation between two table

[basilyos]

hello Guys i need your help with my movies library it's for my own use

i have 2 tables
1. Actors Table
2. Movies Table

i create a third table so i put manually the id of an actor than the id of the movie belong to this actor

so in the third table we could see the movie more than one time because there are many actor in the same movie

please look at the picture i hope i could explain what i have

my question is could i get the result in the third table or anything but with an easier method because it takes too much time to finish it i have more than 1000 film

thanks in advance

 

[jdraw]

Here is a free data model that may help you.
See the movie_people table

 

[basilyos]

jdraw thanks but i didn't understand what should i do

my question was if there is a simple method than putting the info manually in the third table

 

[plog]

We know where you want to go, but where are you? What does your data look like that you are moving into this database? Spreadsheets? Website? Word Documents? Post some sample starting data so we know where you are coming from.

 

[jdraw]

Take another look at the tables and the relationships involved --especially the movie_people table