Duplication is a PAIN in the ###!!

Hi there, this is either

a) An ASP code Problem.
b) An SQL Syntax Problem
c) An Access DB Problem

I have my Syntax right when it comes to INSERTING an Actor and a Movie, then joining them in a JOIN TABLE (tblMovieActor). All good so far, but wait a second! What if I have to type in the same actor's first and last name again when I enter another movie into the database.

WONDERFUL!! (not!) Now I have the same actor's F/L name in there when I only need it once! It's the join table that is supposed to reflect which actor (fldActorID) is in which movie (fldMovieID). It doesn't matter how many times the Actor's ID is in there, because it's SUPPOSED to be repeaded in THAT table, not the F/L name in the Actor's Table.

How do I fix that??? If you'd like to see an example, I can copy/paste the code in here, or have a zip file with all of the current files so you can see for youself.

Can anyone help??

See

http://forums.aspfree.com/t24099/s.html

S-