Relationships don't show in Layout
I have two tables: a Student table, listing all students, and an Attendance Table with fields relating to each month of the project.
I want to enter the total attendance for each month for each student, with the Student ID and Names pulled from the Student table.
I have related the "__pkStudentID" field in the Student table to the "_fkStudentID" field in the Attendance Table.
In creating the Attendance Layout, I pull the "__pkStudentID" field onto the layout, along with Student Last and First Names from the Student table. I expect to see the 147 records and Student ID show up, but nothing happens. No relationship shows up.
Your help is much appreciated. Thanks. Leecy