Event management: how do I set up multiple events per attendee?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to track events such as classes, tours, etc. in a convention
like setting. Can I do this with the event management template?
 
suggest you create a database using the Event Management template, then
explore the database to determine if it will support your particular data
storage and manipulation needs.

hth
 
I entered data and it looks like there is a 1 to 1 relationship between event
and attendee. I just wondered if I missed something.
 
I have'nt seen this sample but what you probably need is a many-to-many
relationship between events and attendees. You need a 'Junction' table to
manage this - say tblEventAttendee. Each record should consist of an Event
ID and an Attendee ID. You can make these two fields joint primary keys to
avoid duplicate entries.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top