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?
Append Queries: https://599cd.com/append
Combo Boxes: https://599cd.com/combo
ABCD Database: https://599cd.com/ABCD
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 add a combo box to the subform so you can see what kind of a phone number it is: cell, home, work, fax, etc.
MEMBERS ONLY VIDEO:
BECOME A MEMBER:
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
Richard's Blog: https://599cd.com/blog
Access Forum: https://599cd.com/AccessForum
Email Me: email@example.com
microsoft access, ms access, #msaccess, multiple items, many items, many phone numbers, many email addresses, many addresses, multiple addresses
Please feel free to post your questions or comments below. Thanks.