Properly Store Multiple Phone Numbers in your Access Database

In this video, I will show you how to store multiple phone numbers for each customer in your Microsoft Access databases using a one-to-many relationship and a subform. The same technique applies whether you have phone numbers, emails, addresses, etc.

Curtis from Denver CO (a Silver Member) asks: In your classes you show adding one phone number for each customer, but I have a situation where a customer may have anywhere from 1 to 10 or more phone numbers. Do I make Phone1, Phone2, etc.? What's the best way to handle this?

Members

I'll show you how to add a combo box to the subform so you can see what kind of a phone number it is: cell, home, work, fax, etc.

•  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!

Links

Relationships: https://599cd.com/relationships
Append Queries: https://599cd.com/append
Combo Boxes: https://599cd.com/combo
ABCD Database: https://599cd.com/ABCD

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 Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Merch Store - Get your swag here! Questions? Please feel free to post your questions or comments below or post them in the Forums.