Meeting form form for established membership

[Mark S]

I am using Access 2007 and Access 2002-2003 and have an established
membership database. I want to start adding forms to track membership
meetings held twice a year.

I am not sure how best to design the additonal forms to see established
members and guests that might attend the meetings. I am looking for design
ideas about how to lay this out. Would I have the form show a meeting and
have a subform show who is attending or vice versa. My goal was to easily
see the participants by meeting rather by member because we have guests
sometimes. Are there any templates out there or can someone give me some
suggestions.

The only additonal information is meeting name and if members will have
dinner. If they are paying with credit cards track the card information. Any
ideas appreciated.

mark S
(e-mail address removed)

 

[Bob Quintal]

I am using Access 2007 and Access 2002-2003 and have an
established membership database. I want to start adding forms
to track membership meetings held twice a year.

I am not sure how best to design the additonal forms to see
established members and guests that might attend the meetings.
I am looking for design ideas about how to lay this out. Would
I have the form show a meeting and have a subform show who is
attending or vice versa. My goal was to easily see the
participants by meeting rather by member because we have
guests sometimes. Are there any templates out there or can
someone give me some suggestions.

The only additonal information is meeting name and if members
will have dinner. If they are paying with credit cards track
the card information. Any ideas appreciated.

mark S
(e-mail address removed)

For my business association's monthly meetings, I added two
tables, meetings (holds the venue, date time, maximum attendees
etc. and an Attendance table. attendance contains foreign keys
to members.memberID, meetings.MeetingID and flags to indicate
paid, guests, etc. Mainform is based on meetings, subform
attendance, member is selected in subform via combobox. I just
add rows to the subform as the confirmations come in .