Handling Emails and Phones in Access


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Q:  Arne Johnston writes that he has four phone number fields in a table, but that is not enough.  How can he handle this better?

A:  For phone numbers, emails and other IDs, a separate linked table is best.  I have one with just three fields: CompanyID (links to the main table), Description, and IDOrPhone.  This technique is more flexible, since you can add info for any type of ID, phone, etc., even new ones that weren’t foreseen when you created the table, such as Twitter handles or URLs.  Here is a typical example, with the linked IDs and Phones displayed in a subform:

img 545fce3d7f60a - Handling Emails and Phones in Access

subs profile e1563205311409 - Handling Emails and Phones in Access
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address