attendance roster with multiple data

[B. Mitchell]

OK. I am willing to start over from scratch.

Trying to create a database that tracks training attendance and gives credit hours to each attendee. I figured most of it out, but I could not get multiple training items in one record to credit hours to multiple attendees.

For example; I will have one record to input multiple persons attending multiple training on one day with hours for each training item.

I searched the forums like crazy and didn't find what I need. If there is a sample database that does this I can dissect and copy it.

Please help.

[comment]

I am not sure I follow this fully, but it sounds like you should have a separate record for each individual attendance, such as:

PersonID:

CourseID:

Date:

Hours:

[B. Mitchell]

Yes that is what I was thinking however. The end user needs to enter the data in a form that allows selection of Attendees up to 45, Up to 5 different training topics and hours for those topics.

Is there a way to have a user screen allow the input and a script create individual records onto a separate table for each of the topics entered?

[comment]

The user can easily enter the data into a portal. Only one attendance table is required (encompassing all topics). See the attached for something similar (though simpler than what you need).

Attendance.zip