False positives with duplicate search

[bigmac]

Whenever I search for duplicates in my parts database (250 000 records), it treats V = W, wich means

filemaker treats the below numbers as duplicates

XW4Z-3530-BV

XW4Z-3530-BW

Why is this?

[Raybaudi]

Hi

double check that that field isn't a number field !

It must be a text field.

[bigmac]

it's a text field indeed.

[comment]

Can you post a stripped down file? Just a single table with the problematic field and a few records to show the problem should do.

[bigmac]

Here ya go

duplicate_test.fp7.zip

[comment]

Are you Swedish?

[bigmac]

yeah -)

[comment]

I don't speak Swedish, so I don't know why this is, but it seems you can tell Filemaker to ignore the difference between "v" and "w" when indexing a field. That's what you currently have.

[bigmac]

I think you found the solution. Thanks alot!!!