Welcome to SPN

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

Sign Up Now!

Capture multiple categories per record

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

  1. mes

    mes
    Expand Collapse
    Guest

    I am trying to set up a database to track many individuals for an event. We
    are wanting to capture many different things associated with each individual.
    Each individual may fall into more than one category and may be involved in
    more than one event. How can I set it up to where I have one record per
    individual, but can have a place to list all the categories they fall in and
    all the events they will be involved in, without having to make a field for
    each category and inserting a yes/no? We will want to be able to query by
    category, by event, by individual, etc.
     
  2. Loading...

    Similar Threads Forum Date
    UK Pakistani-British MP offers reward for Obama's capture Breaking News Apr 17, 2012
    India Cop captured on camera beating up woman in Punjab Breaking News Jan 23, 2012
    SciTech Captured: 'Atmospheric Signature' of Tsunami Breaking News Jul 17, 2011
    Canada Conservatives Capture Their Majority with NDP Forming an Historic Opposition Breaking News May 3, 2011
    Events When Sikhs captured the Red Fort History of Sikhism Sep 2, 2010

  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Like so

    Individual
    IndividualID
    ....

    Category
    CategoryID
    ....

    IndividualCategory
    IndividualID
    CategoryID

    Pieter


    "mes" <mes@discussions.microsoft.com> wrote in message
    news:061A6065-608E-49AB-A9A4-0C8FB5495A0D@microsoft.com...
    >I am trying to set up a database to track many individuals for an event.
    >We
    > are wanting to capture many different things associated with each
    > individual.
    > Each individual may fall into more than one category and may be involved
    > in
    > more than one event. How can I set it up to where I have one record per
    > individual, but can have a place to list all the categories they fall in
    > and
    > all the events they will be involved in, without having to make a field
    > for
    > each category and inserting a yes/no? We will want to be able to query by
    > category, by event, by individual, etc.
     

Share This Page