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!