An Academic Question (aka I'm confused)

[hrenee]

Ok, in the wake of issues I've been reading, a lot. I just read this blog entry (http://rogersaccessblog.blogspot.com...ase-study.html). Problem 2 the multiple yes/no fields, and how he makes a third table with relationships to the IDs of 2 other tables. I get the theory, but I'm having problems with the visualization and application. When you create that third table you then have two columns which really have nothing to do with each other next to each other. I just don't quite get how we go from this integration table to the answer.



Can someone send me in the right direction, where it may just get dumbed down a bit more.

[June7]

The third table is a 'junction' table that associates records of two other tables that have a many-to-many relationship. For example, high school teachers and students. Teachers have many students and students have multiple teachers. Associating teachers with students is done in the junction table.

tblTeachers
ID
LastName
FirstName

tblStudents
ID
LastName
FirstName

tblTeachersStudents
TeacherID
StudentID

When you want to view the information that is related to the ID fields in tblTeachersStudents, build query that joins all three tables.

[hrenee]

Ok, so it's really just a place holder for the data, and I'm only going to use it in a query or form setting?

Like if I wanted to know every student Teacher Brown had?

[June7]

That's why it's called 'relational' database. Otherwise, do a spreadsheet (big, clutzy flat file with tons of duplicated data).