Track Meeting Attendees

[David Oboyski]

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
--
David Oboyski

Access 2003 (11.8166.8202) SP3

Outlook 2003 (11.8169.8172) SP3
with BCM (2.00.5324.00) Update SP2

 

[Golfinray]

A form would easily handle what you want to do and save your data in tables
for you. Forms and subforms are a one to many relationship. The mainform is
the one, the subform is the many. Whet you have to decide is what will be
the mainform or one side. I could be attendees, it could be all people who
may possibly ever attend a meeting. Your subform or subforms would be the
many side, that is the meetings, orgainizations etc. You may need two
subforms one for meetings and one for attendees. I can't tell you exactly how
to structure it. Use the form wizard to build your form for you. Use the
subform wizard to build the subform(s) and it will connect them properly for
you. You can then use command buttons (and he command button wizard) to build
a search function for you (like to search for attendees) and a save function
so that any new data or new attendees are saved. Good luck!