creatng membership register

P

propref

I have created a database table containing contact details of club members. I
now want to add a way of recording which events they attend and how many
guests they bring. The idea being so we can monitor which of our members are
active
Any idea how I can best achieve this.?

Thanks

Chris
 
M

mnature

tbl_Events
EventID
EventInfo

tbl_Members
MemberID
MemberInfo

tbl_MemberEvents
MemberEventsID
EventID
MemberInfo
NumberOfGuests

Have a table that lists all of your events. Then use tbl_MemberEvents to
record those members that have attended a particular event, and how many
guests they have brought.
 
M

mnature

Oops. That's what I get for talking on phone while typing . . .

tbl_MemberEvents
MemberEventsID
EventID
MemberID <----- typo'd this in other post
NumberOfGuests
 
L

Larry Daugherty

You have tblMember. If there is any possibility whatever that a guest
could become a member, I'd recommend making the original table
tblPerson and have a Boolean flag for Member.

Create tblEvent that will capture relevant particulars for each event.

Create tblMemberEvent which will capture activities of this member at
this event.

Create tblGuest which be related to tblMemberEvent.

A typical user interface would base a form, frmMemberEvent, on a query
on tblPerson where field Member is True. The Event is selected from a
combobox. This main form will contain a subform based on a query on
tblGuest

Whether or not that's "best", that's how I'd start it.

HTH
 
Top