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.