If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Relationship tables
I am trying to set up a database for a teaching programme. I first set up 4
tables called 1. tblStudents 2. tblCourses 3. tblTutors 4. tblVenues I have set up a unique primary key for each table StudentID CourseID TutuorID VenueID I then created another table called Student_Courses containing StudentID and CourseID and put a one to many link between this table and the Student and Course Table. Which has linked these 2 tables? I now what to connect the tblTutor and tblVenue to the tblCourse in a one to many format but when I try to connect tblTutor to tblCourse I get an error message “No unique index found for the referenced field of the primary key” What am I doing wrong? And How can I connect up all these tables |
#2
|
|||
|
|||
Relationship tables
It's telling you that you don't have a primary key on tblTutors or you're
not using that field to create the relationship. Take another look and see if you've actually created the primary key like you think you did. -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "paulinep" u50531@uwe wrote in message news:935ec1e06b0ac@uwe... I am trying to set up a database for a teaching programme. I first set up 4 tables called 1. tblStudents 2. tblCourses 3. tblTutors 4. tblVenues I have set up a unique primary key for each table StudentID CourseID TutuorID VenueID I then created another table called Student_Courses containing StudentID and CourseID and put a one to many link between this table and the Student and Course Table. Which has linked these 2 tables? I now what to connect the tblTutor and tblVenue to the tblCourse in a one to many format but when I try to connect tblTutor to tblCourse I get an error message "No unique index found for the referenced field of the primary key" What am I doing wrong? And How can I connect up all these tables |
#3
|
|||
|
|||
Relationship tables
Roger Carlson wrote:
It's telling you that you don't have a primary key on tblTutors or you're not using that field to create the relationship. Take another look and see if you've actually created the primary key like you think you did. Thanks for that, problem sorted. -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|