Hello. I know how to prevent duplicate fields by going to Index in design view and setting it to no duplicates, but how do I set records to not be duplicates?
For example, I have 3 tables
Table 1 - a list of movies. Fields - AutoNum, Movie Name
Table 2 - a list of actors. Fields - Autonum, Actor name
Table 3 Relationship table showing which movies have which actors. Fields - Autonum, movie, actor
Now, an actor can be in multiple movies, and a movie can have multiple actors.
But when I'm entering the data into the relationship table I don't want to enter the same movie - actor combination twice, but each record still has a unique autonum.
How do I do this?