I'm creating a database to track student tardies. I have one table that
contains the student info, with StudentID as the primary key. I also have a
Tardies table that uses Date and Period as combined keys, and also has a
Remarks field and is joined on StudentID in a one-to-many relationship.

I have a query that shows StudentID, LastName, FirstName, Date, Period, and
Remarks. I've created a Form with a combo box to select the StudentID, which
then fills in the LastName and FirstName fields. I also have an Option Group
for the seven periods in a day.

The purpose of this Form (which is based on the above query) is for a
teacher to click the Combo box, select the student's ID number, which puts
the name in the correct fields, then allows the teacher to select the period
the student is tardy for.

The problem is that in my sample data, if a student has more than one tardy,
his/her name shows up for each tardy. This form should only be an Input form;
another form will show total tardies.

Any ideas?

Jim