Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Design question re duplicates & normalization

Status
Not open for further replies.

lmcc007

Technical User
May 7, 2009
164
US
I am using Access 2007. I am trying to create a job searching database. The problem I am having is with the phone number field. Sometimes there may be six different phone numbers. I looked at Microsoft contact management templates and the templates or database examples have 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?
 
<You haven't really addressed my statement regarding a company having multiple assistant phone numbers. You need to decide what should be allowed or not and set the unique indexes to enforce your decision.>

I am still in my classes--trying to get the basic--setting up the tables.

But, I plan to have a company table with information about the company.

A phone number table so there won't be a limit on the phone numbers.

Three unique index fields--PhoneType, PhoneNumber, PhoneExtension. I played with a dummy table and it work. Like, a company can have a main number for everyone but different extension.

I'm learning--slowly but surely. My mind gets confused when I try to do too much or can't figure something out.


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top