Unique Key

[kevin plummer]

Hi All,

Is there a problem if a field has a value of blank and that field is the Unique Field for a key?

I have several tables with blank fields which represent no code. In the browse for these tables if  sort on this field, I cannot select any other record in the browse. If I sort on the next field then it is ok.

Cheers,

Kevin

[Bruce]

Hi Kevin,

two issues here -

if you have several records with the blank field, then how is the key unique?

and yes - the identifier field for a row will cause problems if it is blank.

cheers
Bruce

[kevin plummer]

several tables with 1 blank field each so unique.

As a workaround, I'm going to just fllter out the blank record which I think works better anyway