Help with student attendance database

Help with student attendance database

Hi,

I'm trying to create a database to input and manage student attendance at my lectures and labs. I have created a form with:

Date
Class Type (Lecture/Lab) - dropdown menu
Student Names - all student names as a checkbox list

I want to use this with my iPhone so I can input student attendance at the start of class. The data entry works well, however, when i 'view' the data, all students in attendance are lumped into one cell. So, how can i modify what i have so that when i view the inputted data, each student is treated separately? I want to track student attendance over time, so having a method for doing that after the data has been entered is what i'm after.

Any help would be appreciated.

Grant.