duplication of names

[Guest]

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.

 

[Rick B]

Change the field's Indexed property to "Yes(NoDuplicates)"

Rick B

 

[Guest]

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

 

[Guest]

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)

 

[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?

 

[Guest]

Levette,

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

Sprinks