What are "relationships?"

Relationships are links that associate a field in one table with a field in another.

An example is a school database with two tables:

• Students
• Classes

The Students table holds students' names and addresses:

Students
Student Name	Address
John	Elm St.
Jane	Oak St.

The Math Class table holds information about the students in math class:

Math Class
Student Name	Grade
John	A
Jane	B

Both tables have a Student Name field.

By linking the Student Name fields, you make sure that John in the Students table is the same John listed in the Math Class table:

Students		Math Class
Student Name	Address	Student Name	Grade
John	Elm St.	John	A
Jane	Oak St.	Jane	B