?
Solved

Should I use a lookup table or select query?

Posted on 2008-06-19
3
Medium Priority
?
1,211 Views
Last Modified: 2013-11-28
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?

Thanks
terry
0
Comment
Question by:future_hooves
3 Comments
 
LVL 18

Accepted Solution

by:
jmoss111 earned 100 total points
ID: 21824401
Thats how I do it; it cuts down on maintenance and possibly forgetting to update the table also.
0
 
LVL 8

Assisted Solution

by:Emil_Gray
Emil_Gray earned 100 total points
ID: 21826641
Lookup tables are generally a bad idea for various reasons.
0
 

Author Closing Comment

by:future_hooves
ID: 31468883
Thanks for the confirmation.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question