I have taken over memebrship of a not for profit organization and the DB is MS access 2007.

[jim taylor]

The problem is that the only thing that is working is the membership table:

LastName
FirstName
MembershipType
E-Mail
...

What I need is to have a table of events that occur and a way to get reports on who attended each of the events.

I have built and populated an event table with the following fields.



EventTitle
EventDate
EventType
EventLocation

This is where I am stuck. What do I need to do in order to track who attended each of the events and produce reports.

I know this is a nube question. But once I have that figured out I think I will be well on my way to creating other functions like tracking donations etc.

Much appreciated,

Jim

[June7]

Membership and Events have many-to-many relationship. Need a 'junction' table that associates members with events.

Maybe you need a better understanding of relational database concepts. Review http://www.rogersaccesslibrary.com/

Might also look at the MS Desktop Event Management database template.