Consolidating Multiple Small Tables into One Table using Helper Data

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?

Members

I'll 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.

•  01. Free TechHelp Video
•  02. Extended Cut Video - Silver
•  Database Template Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

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

• Relationships: https://599cd.com/relationships
• Combo Boxes: https://599cd.com/combo
• ABCD Database: https://599cd.com/ABCD
• SQL: https://599cd.com/sql

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.