Hi Craig:
Thank you for your reply. Please bear in mind that I'm in China, so there's a 7-hour time difference between us. I clicked on the link you sent me, thank you, but that doesn't seem to answer my initial question. My question isn't about inserting multiple records, but about how to keep student attendance on a daily/weekly/monthly/semester basis. Also, having the teachers entering the student info every day or week, as your example suggests, would be very cumbersome.
The idea would be to display the students' records, select whether they were present or not in the appropriate field, and then update the multiple records. Perhaps my question wasn't very clear to you. I know how to display the students' records so that the teacher can update them, but would it be possible to insert yes/no data in a different day-field of the student record to check attendance? (meaning having a DB field for Monday, one for Tuesday, etc.)
Otherwise I would have to generate a new record for each class-day, which would be OK, but would mean storing tons of records (i.e. 20 per month per student)
I hope this time my question is a bit clearer.
Thank you for your attention