Results 1 to 3 of 3

Thread: Lookup Table

  1. #1
    Join Date
    Feb 2004
    Alpine Califormia

    Unanswered: Lookup Table

    Can someone explain the purpose of a look up table please. I'm just trying to make sure I'm understanding this correctly
    Last edited by desireemm; 10-01-10 at 18:56.

  2. #2
    Join Date
    May 2010
    Basically it holds the list of valid options. Commonly used as the row source for a combo box.
    Boyd Trimmell aka HiTechCoach (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    depends onwhaqt you mean
    Access provides an option called the look up wizard... which is, in my books an abomination to be avoided at all costs...
    and what db developers refer to a look up table
    a lookup table is another table which has a collection of options
    it could be, say, 'titles', such as Mr, Mrs, Prof, Miss, Ms what ever
    it could be say, shipping options such as post, courier, parcel, fedex, ups etc....
    it could be say product types in a product table.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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