|
||||||
|
Multiple Phone Numbers By Richard Rost ![]() ![]() 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? MembersI'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.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
|
Learn MoreFREE Access Beginner Level 1 Free TemplatesTechHelp Free Templates |
ResourcesMailing List - Get emails when new videos released Questions?Please feel free to post your questions or comments below or post them in the Forums. |
Age | Subject | From | |
9 months | Combo Box | William DeGrandis | |
| |||
Keywords: TechHelp Access multiple items, many items, many phone numbers, many email addresses, many addresses, multiple addresses multiple email multiple addresses PermaLink Store Multiple Phone Numbers in Microsoft Access |