AnsweredAssumed Answered

Help needed with movie database

Question asked by pod2189 on Dec 21, 2008
Latest reply on Jan 5, 2009 by TSGal

Title

Help needed with movie database

Post

Hi all

 

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 

Outcomes