Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2002
    Posts
    7

    Unanswered: Access 2000 Table design

    While using Access 2000 for a couple of years now, I am still a high-end newbie, low-end intermediate user.

    I have a question, over attheaccessweb.com they have an article about Never using Lookup Fields and why.

    I would like to know though, IF you don't use a lookup field, how do you accomplish the task of getting all the info in easily and correctly?

    Right now I am moving my data from a 2yr old db and trying to clean up and make a better db...I have Companies in my db, and Companies have different types. In my old db, I used a lookup field to "lookup" to the types table and got the info from a dropdown list.

    If I don't do this, I would have to keep a list? of types, and manual enter?
    Please enlighten, would love to discuss and learn.

    "For a succesful technology, reality must take precedence over public relations, for nature will not be fooled.

  2. #2
    Join Date
    Apr 2002
    Posts
    7
    Sorry that is the wrong URL
    here is the right one:

    theaccessweb

  3. #3
    Join Date
    Mar 2003
    Location
    Knoxville, TN - USA
    Posts
    27

    Another Link


  4. #4
    Join Date
    Apr 2002
    Posts
    7

    reply

    yes that is the article I am siting. While they tell you the Evils of lookup fields, they dont really explain how to do it without lookup fields.

    More info appreciated please.

    V & V Ree
    www.groundworkssoftware.com

    "For a succesful technology, reality must take precedence over public relations, for nature will not b fooled."

Posting Permissions

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