Reply to thread

Message: [QUOTE="lmcc007, post: 13204815"] I am using Access 2007. I am trying to create a job searching database. The problem I am having is the phone number field. Sometimes there may be six different phone numbers. In all the examples I have looked at, they have all separate fieldsâ€”that is, Work Phone, Home Phone, Car Phone, and so on. Is there a better way to set this up? Is there a way to save data from four different fields into one field? I have the following fields: PhoneType1 = Business Phone1 PhoneType2 = Business 2 Phone2 PhoneType3 = Business Fax Phone3 PhoneType4 = Mobile Phone4 As you can see above that Phone type is repeated over and over again. There should be no duplicates phone numbers for a company. The phone numbers needs to be in one column in order to sort, filter, and find. Also, I want the four PhoneType fields to always be displayed on my form until I decide to change the type it. Any suggestions? Thanks! ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. [URL]http://www.microsoft.com/office/community/en-us/default.mspx?mid=ee32f1ce-eb9e-464a-8b24-583b3534363f&dg=microsoft.public.access.tablesdbdesign[/URL] [/QUOTE]