Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

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

Discussion in 'Information Technology' started by earlylynn, Jul 28, 2006.

  1. earlylynn

    earlylynn
    Expand Collapse
    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?
    --
    earlylynn
     
  2. Loading...


  3. tina

    tina
    Expand Collapse
    Guest

    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


    "earlylynn" <earlylynn@discussions.microsoft.com> wrote in message
    news:399AEEAB-CD94-427B-B91C-E0F4C57CB15F@microsoft.com...
    > 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?
    > --
    > earlylynn
     
  4. earlylynn

    earlylynn
    Expand Collapse
    Guest

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

    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.
    --
    earlylynn


    "tina" wrote:

    > 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
    >
    >
    > "earlylynn" <earlylynn@discussions.microsoft.com> wrote in message
    > news:399AEEAB-CD94-427B-B91C-E0F4C57CB15F@microsoft.com...
    > > 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?
    > > --
    > > earlylynn

    >
    >
    >
     
  5. Jon Lewis

    Jon Lewis
    Expand Collapse
    Guest

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

    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
    "earlylynn" <earlylynn@discussions.microsoft.com> wrote in message
    news:9335765F-14EF-4185-9A2E-EFB8282490AB@microsoft.com...
    >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.
    > --
    > earlylynn
    >
    >
    > "tina" wrote:
    >
    >> 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
    >>
    >>
    >> "earlylynn" <earlylynn@discussions.microsoft.com> wrote in message
    >> news:399AEEAB-CD94-427B-B91C-E0F4C57CB15F@microsoft.com...
    >> > 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?
    >> > --
    >> > earlylynn

    >>
    >>
    >>
     

Share This Page