There are several things to keep in mind when creating relationships between fields.
- Be sure that each table in the relationship window is showing all its fields. If you see a vertical scroll bar for the table, drag the bottom right corner lower until all fields are showing.
- MOST IMPORTANT - The fields being related must be "in common." That is, they must have the same field name and the same data type.
- When dragging and dropping field icons, you must be careful to place the icon precisely on the correct field.
- It is not necessary for every table to be connected to every other table, only that the tables be connected by a single path.
- Arrange the tables so that no lines are crossed and the connections are clear. See the illustration above.
- For primary key fields, avoid using "ID" as the field name, as this can mislead you to create relationships between them. Instead, use names such as those above, "StudentID" for the primary key field for the Students table, "SubjectID" for the primary key field for the Subjects table, and so on.
There are several things to keep in mind when creating relationships between fields.
