Consolidating Multiple Small Tables in Microsoft Access into One Table using a Helper Data Table

Do you have a million tiny tables in your database? Name prefix, suffix, title, lead source, marital status, gender, the list goes on. You want to store this information in a table (properly so) because you want to be able to easily edit the list and use that same list anywhere in your database. However, all those tons of little tables in your Navigation Pane are annoying and clutter your database. In this video, I'll show you how to consolidate all of those tiny tables into one Helper Data table to keep things nice and tidy.

Sara from Osaka, Japan (a Gold Member) asks: Help! I've got way too many tables and linked tables in my database. Most of them are small with only a few records in them, but I need them. I've got tables for: name prefix, suffix, contact type, lead source type, employment status, gender, marital status, the list goes on. Is there any way to consolidate this into ONE table?

BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video will show you how to create a popup form where you can quickly edit the items in the combo box that you're working with, and also how to include the supporting helper data in queries and reports.

MEMBERS ONLY VIDEO:
   • Helper Data - EXTENDED CUT MEMBERS ONLY  

BECOME A MEMBER:
   / @599cd  

UPDATE:
I cover the feature where the HelperF passes the new value back to the combo box that called it in my ABCD Part 2 database lessons: https://599cd.com/1387

LINKS:
Get on my Mailing List: https://599cd.com/YTML
Relationships: https://599cd.com/relationships
Combo Boxes: https://599cd.com/combo
ABCD Database: https://599cd.com/ABCD
SQL: https://599cd.com/sql

ADDITIONAL RESOURCES:
FREE Access Level 1: https://599cd.com/Free1
FREE Customer Template Database: https://599cd.com/XCDT
$1 Access Level 2: https://599cd.com/1Dollar
Your Questions Answered: https://599cd.com/TechHelp
Learning Connection 50% OFF: https://599cd.com/Connection
Survey: https://599cd.com/survey
Richard's Blog: https://599cd.com/blog
Access Forum: https://599cd.com/AccessForum
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
Email Me: [email protected]

KEYWORDS:
microsoft access, ms access, #msaccess, consolidate multiple tables, merge many tables, supporting data tables

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.