Best, Mr. Lacar!
Thank you so much for your kind reply. I am currently and struggling reading the article you posted the link to. It seems that I am getting closer to the answer. I have three person tables in my database, "tbl_castperson","tbl_crewperson" and a third, "tbl_filmperson". I am, shortly to say, linking theese together with foreign keys. But for instance, I can't figure out how to link them to a movie if there are no ones yet added in the database? I have a film_id key in my "tbl_filmperson" referencing to the id key in my main table "tbl_mediatitle". Here is what my person tables look like ( I have shorted them down a little bit from their original structure ) :
Something like that. I don't even know if I am on the right track as I mentioned earlier.
I am using the embedded java derby database for this project.