Access2000: Unique values, but not exactli

[Arvi Laanemets]

Hi

I have some table like:
MyTable: ID, Code, EntryTag

, where ID is an autonumeric (Main Index) field.

What is best way to make Code field do be unique when not empty, but to
allow it be empty for any number of entries. (When the new entries are
entered into table, Code may be not available jet for them. When user later
edits entries and enters missing codes, no code existing in other entries
can be allowed)


Thanks in advance!
Arvi Laanemets

 

[Paul Shapiro]

By default an Access unique index does what you want. It ignores nulls,
although that can be changed via a setting in the index property dialog.
Only non-null values have to be unique. Look up index in the online help for
details.

 

[Arvi Laanemets]

Thanks, it did work!

Somehow I was sure it's opposite and didn't bother to check it over :-((