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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with composite key 4
Referential Integrity Q 3
Primary and Foreign Keys 10
Suggestion on table design 3
No unique index found 3
referential integrity and lookup 2
Composite Primary Key with an ID and Index 2
create an Auto-increment field for use as the primary index betwee 1

Top