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??

If you can post the table structure and sample expected result it will be easy to reply. Any how you can create a select distinct actorid query and join that query with the table to avoid duplicate entries. But only after viewing the table structure correct answer can be given.

If possible attach the MDB and mention the Access version you are using 97 or 2000 with sample record and zip it and post it.

OK the file attached is MovieDB.zip

In it is:

add.asp
default.asp
displaymovies.asp
movieform.asp
movies.mdb (MS Access 2002)
back.jpg (background)
mouse_1.cur (web cursor)

I appreciate all the help!