Want to eliminate Duplicate Values <> Null

I know how to make a column prevent duplicate values with
an index; however, I have a column where many values are
null which is OK, but I can't use an index to prevent
duplicate entries because it will only allow me one
record with the null column value.

Does anyone know of a work around where I can root those
out and at least pop up a warning to the person entering
the record that the value exists in another record?

Thanks in advance,

Ben

On Wed, 7 Jul 2004 16:41:37 -0700, "Ben"
wrote:

I know how to make a column prevent duplicate values with
an index; however, I have a column where many values are
null which is OK, but I can't use an index to prevent
duplicate entries because it will only allow me one
record with the null column value.

Set the IgnoreNulls property of the Index (which cannot be a Primary
Key index, since PK's cannot contain null) to True.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public