Lost My "No Duplicates" in a Field

[skilche1]

OK, here is my issue that I just realized this morning. I have completed a database and it works great except for one issue. This morning as I was adding custom error messages to the a particular field that I do not want duplicate values, I see that I am able to. When I originally set up the table, I was able to configure the field Indexed to Yes (Duplicates Not Allowed). Somehow I lost that option. FYI, I didn't set this field as a Primary Key like I probably should have.

How can work around this issue where a user cannot add the same value. In this instance, the value is a number. If you need to see the database, please let me know and I will post it.

Any help would be greatly appreciated as users are already starting to use this db.

As usual, thank you in advance.

 

[Mr. B]

You do not have to set the field as a primary key field. Try setting the "Indexed" property for the field to "Yes (No Duplicates)".

 

[skilche1]

You do not have to set the field as a primary key field. Try setting the "Indexed" property for the field to "Yes (No Duplicates)".

Hi MrB.

Yes, I have tried that and it will not allow me to, which is why I amwondering if the alternitive method...

 

[jdraw]

What do you mean it won't let you? Does it give an error?
Does the table have a PK?
Can you tell us more about the table?

 

[jdraw]

You have 2 records with Cal# 2517

ToolInfo_Id 339 and 341

Resolve this issue and you could put no duplicates on Cal# if you want.

 

[skilche1]

You have 2 records with Cal# 2517

ToolInfo_Id 339 and 341

Resolve this issue and you could put no duplicates on Cal# if you want.

WOW, thanks jd. I exported the data into Excel and it came up clean for duplicates. Or so I thought...

Thanks, all cleared up now. Now I feel dumb. lol

Have a great day.