Welcome to SPN

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

Sign Up Now!

limiting 8 records to 1 field

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

  1. andywilko101

    andywilko101
    Expand Collapse
    Guest

    i need to limit 8 records to one field. im not really sure what im doin so
    ill give an example of what i need to do.

    each adivsor specialises in up to 8 holidays. a holiday can be assigned to
    many advisors but it cannot be assigned twice to the same advisor.

    thanks if u can help.andy
     
  2. Loading...


  3. BruceM

    BruceM
    Expand Collapse
    Guest

    You need to provide more information. What is the real-world situation
    behind your question? How is your data base set up? While you're at it,
    use standard English writing conventions, or a good number of people here
    will ignore the question.

    "andywilko101" <andywilko101@discussions.microsoft.com> wrote in message
    news:5661883E-E2D6-41C0-9582-8CBE086F8BFA@microsoft.com...
    >i need to limit 8 records to one field. im not really sure what im doin so
    > ill give an example of what i need to do.
    >
    > each adivsor specialises in up to 8 holidays. a holiday can be assigned to
    > many advisors but it cannot be assigned twice to the same advisor.
    >
    > thanks if u can help.andy
     
  4. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    You need three tables as you have a Many-to-Many relationship:

    Advisors (with something named like AdvisorID as the primary key)

    Holidays (with something named like HolidayID as the primary key)

    Adv_Hol with the combination of the AdvisorID and HolidayID as the primary
    key or at least a unique constraint. That way an Advisor can only be assigned
    to a particular Holiday one time. You enter the combination of Advisors and
    Holiday combinations into this table. If you accidentally try to give the
    same advisor the same holiday more than once, Access will complain.
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "andywilko101" wrote:

    > i need to limit 8 records to one field. im not really sure what im doin so
    > ill give an example of what i need to do.
    >
    > each adivsor specialises in up to 8 holidays. a holiday can be assigned to
    > many advisors but it cannot be assigned twice to the same advisor.
    >
    > thanks if u can help.andy
     

Share This Page