Duplicate Entries in Phone and Email Fields

[Guest]

Is there a way to prevent duplicate entries in a table that has phone and
email fields that are blank, but the blank ones need to stay but duplicate
numbers and emails of value need to be prevented. I don't know anything
about code, just work in Access, so if anyone could help it would be greatly
appreciated.

 

[Douglas J Steele]

Create a unique index on the field, and tell it to ignore nulls.

You do this by select Indexes from the View menu when you've got the table
open in Design mode. Select a name for the index in the first column (the
name can be anything you want), select the field in the second column. The
sort order doesn't matter.

 

[Guest]

Thank you very much!

Create a unique index on the field, and tell it to ignore nulls.

You do this by select Indexes from the View menu when you've got the table
open in Design mode. Select a name for the index in the first column (the
name can be anything you want), select the field in the second column. The
sort order doesn't matter.