Event Mgmt 2000

[AMyers]

Membership Database is currently kept in 2000 Access; I now want to start
tracking event(s) and registering attendance for such events. I was going to
use the sample database for Events; Importing from the Mbrship Database the
Contact Information. How is the best way to accomplish?

 

[Damian S]

Hi AMyers,

Have a table with Event Information in it, eg: called tblEvents. Have
another table to link Members to Events, eg: called tblMemberEvents,
containing the MemberID and EventID.

Hope this helps.

Damian.

 

[Joan Wild]

It depends on whether the imported Members are going to be used as Attendees
or Employees in the Events database - more info please.

You should not import the members, but instead link to the members table in
the Membership database.