Handling Emails and Phones in Access
Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Delivered once a week. free.
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:
Office Watch has the latest news and tips about Microsoft Office. Independent since 1996. Delivered once a week.