Multi-field index

[lmcc007]

I have a tblPhoneNumber table with five fields:

PhoneNumID
PhoneTypeID
PhoneNumber
PhoneExt
CompanyID

I created two indexes using the Indexes button on the Show/Hide ribbon.

PhoneTypeIndex includes: PhoneTypeID and CompanyID. Which works--I can not create the same phone type for a company.

PhoneNumberIndex includes: PhoneNumber and PhoneExt. It does not work. I only want the phone number to be repeated if the phone extension is different.

What am I doing wrong?

Thanks!

 

[genomon]

What am I doing wrong?

You are trying to index non-unique data. Get rid of the duplicates (maybe with some VBA/SQL or a delete query) before they are inserted into the table.

Ever notice how fast Windows runs? Me neither.

 

[lmcc007]

Ok, duplicate query. Gotcha!