Welcome to SPN

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

Sign Up Now!

Simple Question

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

  1. Bill

    Bill
    Expand Collapse
    Guest

    I have a simple question but since I'm newish to access it's puzzling me.

    I need to create an event management database where I track who from table1
    is going to what events on table2. I've been trying to create table2 so each
    event is an entry and then one of the fields would be a list of multiple
    members of table1 but cant figure out how to do this. Is it possible the way
    I've described it, and if not what's the best way to do it?

    Thanks in advance
     
  2. Loading...

    Similar Threads Forum Date
    Grammer / Vyakarn Learn Simple & Easiest Gurbani Vyakaran/grammer From Prof. Maninderpal Singh Language, Arts & Culture Mar 9, 2015
    General Babaji Ranjit Singh Dhandrian Wale, Simple living high Thinking Hard Talk Sep 27, 2013
    Sikh Weddings Simple? No, they Are Indulged In Brahmanwad Questions and Answers Sep 15, 2012
    The One-Minute Mystic: Simple Things You Can Do to Stay Connected Spiritual Articles May 23, 2011
    Being a Simple Sikh (blog of a Prithihardkaur Sikh) Spiritual Articles Sep 13, 2010

  3. Jeff L

    Jeff L
    Expand Collapse
    Guest

    Table1 would be for your individuals(ID, Lname, Fname, etc)
    Table2 would be for your Events(EventID, EventName)
    Table3 would serve as a link between the two (EventID, ID)

    In Table3 your entries would look like
    1 1
    1 2
    1 3
    1 7
    1 10

    That's probably how I would do it.

    Hope that helps!
     
  4. Bill

    Bill
    Expand Collapse
    Guest

    Thank you for your post!

    So I would need to create a new table for every event I held then? I guess
    I'm just a little confused as to the structure of the relationships.

    Thank you in advance...

    "Jeff L" wrote:

    > Table1 would be for your individuals(ID, Lname, Fname, etc)
    > Table2 would be for your Events(EventID, EventName)
    > Table3 would serve as a link between the two (EventID, ID)
    >
    > In Table3 your entries would look like
    > 1 1
    > 1 2
    > 1 3
    > 1 7
    > 1 10
    >
    > That's probably how I would do it.
    >
    > Hope that helps!
    >
    >
     
  5. Jeff L

    Jeff L
    Expand Collapse
    Guest

    No, Table2, your event table would look like this
    1 Event 1 Name
    2 Event 2 Name
    3 Event 3 Name
    And so on
    Basically this will be a lookup table for all your events.

    The Table3 is how you would assign your people to your events. So if
    my ID in the people table (Table 1) is 3 and I went to three events,
    the entries for me in Table 3 would be:
    EventID = 1, ID = 1
    EventID = 2, ID = 1
    EventID = 3, ID = 1

    Table 3 will hold all the attendees for all your events.

    Get it now?
     

Share This Page