My objective is to track the attendees at meetings.  I'm also tracking other
information about meetings (invitees, agenda items, discussion items, action
items, etc.).  Ideally, I would like a form to check off the names of the
people who attended the meeting.  I'm not sure how to do that.  Here is the
DB I constructed thus far.

I have three tables:

DATA_Meeting
Relevant fields: Meeting_PK, Meeting_Name, Meeting_Organization

DATA_Attendees
Relevant fields: Attendees_PK, Attendees_Meeting_FK, Attendees_Person_FK

DATA_Person
Relevant fields: Person_PK, Person_InformalFirstName, Person_LastName

I would like to create a form:

FORM_Meeting

On that form, I would like to allow the user to select the meeting then (on
a subform?) select the persons that attended the meeting, preferably using a
check list.

I would like the selection to create a record in DATA_Attendees that would
include the meeting foreign key and the person foreign key.  This would allow
me to run reports by person, by meeting, etc.

I need the possible-attendees list to be dynamic.  In other words, if we add
someone to the DATA_Person table, the possible-attendees list would change to
include the new addition.  Conversely, if we delete someone from the
DATA_Person table, the possible-attendees list would change to exclude the
deleted person.

Thank you.

David