Relationship tables

[paulinep]

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

 

[Roger Carlson]

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/wa.exe?SUBED1=ACCESS-L

 

[paulinep via AccessMonster.com]

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.