Auto-enter Problem

[kurtrahn]

I'm creating a school attendance database. Each student has their own record which includes student ID, first name and last name. Each record also has fields for date, time in and time out, which are duplicated 100x (for each potential time they could be marked "present" during a semester). I'm trying to create scripts/buttons that will auto enter date, time in and time out, but it auto fills all the fields when I execute it.

Is there a way to get it to auto-fill for just one field at a time? Or am I going about this wrong?

[bcooney]

Welcome to the forum!

That's the good news. The bad news is that, "yes, you're going about this all wrong."

You need two tables. Students and Attendance, related by StudentID and with Allow Creation of Related records on.

There are two possible ways to build your interface. On a Student layout, create a portal to the related Attendance records.

On an Attendance form, create a new record and enter the StudentID.

Look at field's entry options for having the Creation Date auto-enter. I would think that times would be manually entered, as they might be entered by a data entry person, after attendance is taken..

[kurtrahn]

Awesome! Thanks!!