4WebHelp
 FAQ  •  Search  •  User Groups  •  Forum Admins  •  Smilies List  •  Statistics  •  Rules   •  Login   •  Register
Toggle Navigation Menu

 ASP + Access DB + SQL
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic
Author Message
genkidave
Junior WebHelper
Junior WebHelper


Joined: 05 Nov 2003
Posts: 7

PostPosted: Tue Feb 03, 2004 9:47 am (13 years, 8 months ago) Reply with QuoteBack to Top

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?
OfflineView User's ProfileFind all posts by genkidaveSend Personal Message
Display posts from previous:      
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic


 Jump to:   




You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot edit your posts in this forum.
You cannot delete your posts in this forum.
You cannot vote in polls in this forum.


Page generation time: 0.047666 seconds :: 18 queries executed :: All Times are GMT
Powered by phpBB 2.0 © 2001, 2002 phpBB Group :: Based on an FI Theme