Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2009

    Unanswered: Lookup Column or a better way?

    So as part of my work to try to clean up my orginzation's database and make it more accurate, well as much as it's going to get I'd like to convert a couple of column's into lookup tables.

    We have two fields i'm specifically looking at right now, First is the STATE field. The prior administrator limited it down to two charaters, and you have to manually enter the information. I'm thinking it might be helpful to turn this into a lookup column, so that you can select the state or province as nessasary.

    Second is the county field, i made this into a value list to help but i'm thinking a lookup table might be better here as well (say if i could use the "FIPS" codes for the counties instead of having to spell each one out, but could use a drop-down to select the right county by name).

    Is my thinking right here?

    When i try to make the state field into a lookup column, it automatically changes the type to "number" and promptly deletes all my information. I found a website at one time that went into the specifics of how to do all this, but i have list the link.


  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    depends how you intend implimentting the lookup
    if you use a separate table then fine
    if you use the Access column lookup wizsard then not fine.

    the reason
    changes to the underlying data in the column lookup wizard require changes to he db, changes to a table require the suer to enter new data.
    there are other problems with the column wizard when used in queires.

    the cilumn wizard works if you know all outcomes on day one.

    its not clever if the data changes, or if your uses decide that they need more than one column in the 'lookup'
    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