Help needed with movie database
I'm newbie to creating databases but i have created a movie database i have 4 tables film, actors, producers & jointable.
My problem is that i get no serials in to jointable and i don't know why the relation are as follow in film i have film_id related with film_id in jointable, in actors i have actors_id related to actors_id in jointable and in producers i hav prod_id with prod_id in jointable and i want the serials from actors, film and producers inserted automatic to jointable. could any one help with this please.
Thanks in advantage and excuse me if my english is a little bad