What kind of relationship should I use for a two table database?

[receptionist_dude]

Hi all,



How goes it?

I'm working at a tutoring center and we're working on a database that keeps track of each one of our tutors as well as the courses they are approved to tutor. My idea is to create a simple database with two tables: "Tutors" and "Courses," with the possibility to see who tutors any given course as well as what courses a specific tutor covers.

As simple as this sounds I've been off the Access game for a long time and I am having trouble making this work! I am unsure as to how define the relationships between the two tables.

I tried out the following:

• Create a list of tutors in the "Tutors" table. In said table I have two fields-- "name" and "courses tutored."
• Create a list of courses in the "Courses" table.
• Created a relationship between the courses listed in the "Courses" table to the "courses tutored" field in the "Tutor" table. From there I can select multiple courses because most tutors cover more than one course.

The idea is to be able to view reports both ways: the tutors covering a specific course and the tutors who cover a specific course.

I think I am making a mistake with the relationship because the dynamic reports are not working.

Does anyone know how to help me through this?

Thank you!

[orange]

Tutor---->TutorCanTeachCourse<---Course

I'd try 3 tables as above where ---> represents a 1 to Many relationship

1 Tutor can Teach Many Courses
1 Course can be taught by Many Tutors

Good luck with your project.

[receptionist_dude]

Thanks, orange!

I'm still slightly confused, but I will give this a try tomorrow morning at work.

What am I supposed to use the third table for?

Can you give me an idea so that I can look up some tutorials?

I just need something to start my search with (like a topic I can look up) because I'm not fully confident yet!

[orange]

Research junction table or [I]linking table or bridging table or associative table

https://en.wikipedia.org/wiki/Associative_entity



Here's a free video tutorial by Steve Bishop many to many

[receptionist_dude]

Thanks!

Here is what I have so far but it still does not seem to work:



What am I missing?

Thanks again!

[orange]

It appears you do not have referential integrity set.
Also CourseID in tbl Course should be joined with CourseID in tblBridge AND
tutorId in tblTutor should be joined with tutorId in tblBridge.

The join lines should show 1 to Many from Courses to tblBridge AND
1 to Many from Tutors to tblBridge