Attendance Book Design in FileMaker Pro
I am trying to create an attendance book for my classes and am not having much success. I can create a solution where I browse through each student's info card (record) and check in a portal their status for the day. I would like to be able to utilize this in a spreadsheet layout like using Microsoft Excel, however, I do not want to create a form with all the students names in the class. I want to have a student database and assign them to the class.
Can someone send me a recommendation on how to design/implement this solution? I don't need explicit details, just the rough idea on how to organize it.