duplication of names

L

Levette

I need to know how to stop a duplication of an entry in a table. I do not
want to be able to enter the same name twice. How can I do this.
 
S

Sprinks

Hi, Levette.

You need to create an index, set to No Duplicates.

Load the table in design view, and choose View, Indexes. A table of defined
indexes will appear. Enter a name for the index, select the name field, and
optionally, a sort order.

If your name field is made up of more than one field, like LName and FName,
enter a second FieldName and SortOrder, but leave the Index field blank. It
would look something like:

Index Name FieldName Sort Order
--------------------- -------------------- ----------------
PrimaryKey MyPK Ascending
UniqueName LName Ascending
FName Ascending

Finally, change the Unique property to Yes, close the window, and save your
table.

Hope that helps.
Sprinks
 
L

Levette

It is not letting me save the changes

I have setup a table that has Last Name First Name
Smith John
Smith John ( I don't
want to be able to enter smith john twice)
 
R

Rick B

Well, you told us you don't want to be able to enter duplicates. Now you
tell us you do. I'm lost?
 
S

Sprinks

Levette,

It won't let you save the changes because you have existing duplicates. You
need to resolve these first.

Sprinks
 
Top