Should I use a lookup table or select query?

Hello Experts,

I have a basic Access/dbase question i think.....

When buliding forms for end users should I use lookup tables for the dropdown or Select queries for the dropdowns.  At first I was building using lookup tables but realized if you modify the lkup table it affects all records.  Which leads me to believe I shoud use a select query that extrapulates from a table the data i need.  That way modificatios only effect future records and i could make certain selctions active and in-active...... does this sound correct?

Who is Participating?
jmoss111Connect With a Mentor Commented:
Thats how I do it; it cuts down on maintenance and possibly forgetting to update the table also.
Emil_GrayConnect With a Mentor Commented:
Lookup tables are generally a bad idea for various reasons.
future_hoovesAuthor Commented:
Thanks for the confirmation.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.