Learn 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?
LINKS:
Get on my Mailing List: [ Ссылка ]
Relationships: [ Ссылка ]
Append Queries: [ Ссылка ]
Combo Boxes: [ Ссылка ]
ABCD Database: [ Ссылка ]
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:
[ Ссылка ]
ADDITIONAL RESOURCES:
FREE Access Level 1: [ Ссылка ]
FREE Customer Template Database: [ Ссылка ]
$1 Access Level 2: [ Ссылка ]
Your Questions Answered: [ Ссылка ]
Learning Connection 50% OFF: [ Ссылка ]
Survey: [ Ссылка ]
Richard's Blog: [ Ссылка ]
Access Forum: [ Ссылка ]
Twitter: [ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
Email Me: amicron@gmail.com
KEYWORDS:
microsoft access, ms access, #msaccess, multiple items, many items, many phone numbers, many email addresses, many addresses, multiple addresses
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
![](https://i.ytimg.com/vi/H2ieiUpzcLM/maxresdefault.jpg)