No unique index found for the referenced field of the primary table.

F

fiaolle

Hi
I have two tables (Movie and Categorie) witch I want to link together.

Movie Category
Nr (PK) Number Category (PK) Text
Titel (PK) Text

I have heard that when you have to have a many to many relationship you have
to have a table to link them together (MovieCategory). I have tried it and I
just get the error "No unique index found for the referenced field of the
primary table." when I try to set referential integerity between the fields
Movie.Nr and MovieCategory.Nr.
Can anyone please tell me what to do.

Fia

MovieCategory
Nr Number
Titel Text
Category Text
 
M

mnature

tbl_Movies
MovieID (PK)
MovieName

tbl_Categories
CategoryID (PK)
CategoryName

tbl_MovieCategories
MovieID (PK)
CategoryID (PK)
 
Top