A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Relationship tables



 
 
Thread Tools Display Modes
  #1  
Old March 20th, 2009, 04:38 PM posted to microsoft.public.access.tablesdbdesign
paulinep
external usenet poster
 
Posts: 1
Default 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  
Old March 20th, 2009, 05:21 PM posted to microsoft.public.access.tablesdbdesign
Roger Carlson
external usenet poster
 
Posts: 824
Default 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  
Old March 23rd, 2009, 11:24 PM posted to microsoft.public.access.tablesdbdesign
paulinep via AccessMonster.com
external usenet poster
 
Posts: 1
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:09 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.