Why You Should Avoid the Lookup Wizard and Lookup Fields in Tables in Microsoft Access

In this Microsoft Access tutorial, I will show you how to correctly replace Lookup Wizard fields with a more efficient method, ensuring changes to your product codes only need to be made in one place.

Cameron from Chapel Hill, North Carolina (a Platinum Member) asks: I started building my database before I found your tutorials. I know that you don't like the Lookup Wizard, but I have lookup fields in a lot of my tables, and now I need to get rid of them. I can see why you don't like them. One of the lookup tables that I have is for product codes, and instead of making a separate table for that, I used the lookup field that I copied into four different tables. Now, every time I need to change one of those product codes, either add or delete one, I have to do it in four different places. Are there any tips you can give me for how to set this up properly, and how to easily take my list of a few hundred product codes and put that into a table properly?

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

LEARN MORE:
Lookup Wizard: https://599cd.com/LookupWizard

PREREQUISITES:
Data Types: https://599cd.com/DataTypes

LINKS:
Relationships: https://599cd.com/Relationships
Relational Combo: https://599cd.com/Relational
Value List Combo: https://599cd.com/ComboValueList
Multivalued Fields : https://599cd.com/MVF
Many-to-Many: https://599cd.com/M2M
Update Queries: https://599cd.com/UpdateQ
Evil Access Stuff: https://599cd.com/EvilAccessStuff

RECOMMENDED COURSES:
Access Beginner 1: https://599cd.com/ACB1

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
How to Use Access in 30 Minutes: https://599cd.com/30Minutes
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

KEYWORDS:
TechHelp Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Lookup Wizard replacement, avoid Lookup Wizard, relational database setup, fix multiple table updates, normalization in Access, manage product code changes, Access design view, update queries in Access, avoiding multi-value fields, SQL Server transition, proper Access table setup

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.