Handling Emails and Phones in Access

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Give it a try. You can unsubscribe at any time.

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: