ASP + Access DB + SQL

Junior WebHelper Joined: 05 Nov 2003 Posts: 7

Help me please!!!

1) I have 3 tables in my Acccess Database:

a) tblMovies (fldMovieID (Primary Key), fldMovieName)
b) tblActors (fldActorID (Primary Key), fldFName, fldLName)
c) tblMovieActorJoin (fldActorID, fldMovieID (Both Foreign Keys))

OK, When I add info to my database from my form on an ASP page,
the Movie info and the Actor info are inserted A.O.K, but for some
reason (even though there are realationships for the 3 tables) the
tblMovieActorJoin isn't updated with the fldActorID or the fldMovieID.

In other words: I can't see which actor was in which movies, or
vice-a-versa, which movies have which actors UNLESS I manually do
it within the databse itself, but I need the database to be updated when
I add the info from the form and that would be it.

Any helpfull thoughts?