Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2009
    Posts
    3

    Unanswered: Problem with multiple answers within a field

    I've run into a bit of a brick wall with a database I have been asked to create within access. It keeps a list of people with all their personal information.

    With this database they need a record of the county in which the person resides which was easy enough, I just created a table with a list of the counties in the republic of Ireland and created a relationship etc.

    The problem I seem to have run into is that there are sub areas within each county (e.g. towns and cities). Each person can work in multiple sub areas, some up to nearly twenty, and not always necessarily in the same county. I originally created a form with a load of tick boxes but I'm not sure how to build reports around this e.g. i want a list of people who practice in Dublin City.

    There is also a list of skills that the person has, and again there could be up to 30 different types that a single person has.

    There may be a very obvious way of doing this that I am missing but I'm self taught and am mostly just lucky when things go right for me.

    Any help or advice would be greatly appreciated!

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    You are considering a skills column containing (for example):
    "skateboarding, poker, pole dancing"
    ?

    This is a violation of first normal form - column values should be atomic (i,e, one thing and one thing only). You want a separate table with two columns:
    person_id
    skill

    The Primary Key is (person_id, skill). You can, of course, chose your own names.

    A decent guide to designing relational databases:
    The Relational Data Model, Normalisation and effective Database Design
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jul 2009
    Posts
    3
    Yes, something like that but instead of them having one skill e.g. skateboarding...they are a skateboarding, pole dancing poker player. Thanks for the link...will take a look.

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by MorRioghain
    they are a skateboarding, pole dancing poker player.
    Now I would pay good money to see that
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by pootle flump
    Now I would pay good money to see that
    you are a desperately sad man,
    and in urgent need of therapy...


    I'd suggest you book an appointment at 18:30 on the 17th of July at the Knott bar..
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Jul 2009
    Posts
    3
    Quote Originally Posted by pootle flump
    Now I would pay good money to see that
    I know a few...I'll sort ya out

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •