Indexes do not work

[Jeanette]

I have a table w/buildings addresses separated into fields: One field has street# and the other field has street name. I set an index for these two fields so the the combination of the two fields will not duplicate. Unfortunately, the index does not work; It still allows the input of duplicate addresses. What am I doing wrong?

 

[jeremie_ingram]

Did you set these as a concatinated key? If you can use this as the PKEY for the table, select both fields and set them as the key.

 

[Jeanette]

What do you mean by set them as concatenated? The first column and first row of the index is called address. The second column of the first row is field Name. The first column of the second row is blank and the second column is field Name. Is this not correct. My Primary key is an autonumber and I would prefer to keep it as the Primary Key.

 

[neileg]

The first column and first row of the index is called address. The second column of the first row is field Name. The first column of the second row is blank and the second column is field Name.

I presume you are talking about the Index window. Have you set the properties of the index to Unique by clicking on the Name and setting the option below? If you don't, an index will be applied but it will allow duplicates.

 

[Jeanette]

Yes I was talking about the Index window. And no I did not have the properties index set to Unique. Now that I have it set to Unique it works fine. Thanks