|
||||||
|
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 files from class plus get access to the Code Vault. If you're not a member, Join Today!
|
Learn MoreFREE Access Beginner Level 1 Free TemplatesTechHelp Free Templates |
ResourcesDiamond Sponsors - Information on our Sponsors Questions?Please feel free to post your questions or comments below or post them in the Forums. |
Age | Subject | From | |
14 months | Link between parent subform | Roland Richon | |
2 years | 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 |