Duplicates

[Fluffy]

I have an ID field in a table, stored as text. I have chosen the "unique, no duplicates" option. When I try to enter a string that already exists, it says 'no duplicates', which is good... When I enter a string that already exists in a form, it just stores it!!

The text has an input mask: "PC-"0000 .

Some help would be welcome.

Thx,
Oswald

 

[Len Boorman]

Suspect that the problem is with the input mask.

When you enter directly you get the duplicates message which is correct because you have actually entered a duplicate.

I suspect that when you input via a form what is actually stored is not a duplicate because the leading Text in the input mask is not actually being stored, therefore you do not get duplicate message.

I think that you need to add ;0 to the input mask so that the leading text is also stored.

Maybe some others would like to comment

Len B

 

[Fluffy]

Hello,

it works fine now.

Thank you for your help,
Oswald