Group entry in to log file

[Phil]

Hi

I have a db with two tables with fields as follows:
Name table: name_id (key), last, first, + other fields
Event Table: event_id (key), name_id (from name table),
description, date, comments

The tables have a one (name) to many (event) relationship.

As it works now, I have a form which I use to select the
person and then I click on a command button which brings
up an event form that I fill in the description, date, and
comments. I then close the event form and select the next
person and click on the command button to enter the event
data again for the next person.......

Some of the events have 30-50 people attend and I know
there must be a way that I can enter the event info
(description, date, comments) once and the select a
person, save the record, select the next person, save the
record, etc, and not have to re-enter the event info each
time.

I've tried various approches and can't seem to fine the
solution.

I also need to know how to prevent duplicate entries in
the event file. Duplicate being the same description,
name_id, and date.

Any help?

Thanks,
Phil