unique or not unique

[wollber]

Hi folks, I have the following problem:

one database, every record should be unique as judged by the autovalidation feature for the text field "oligo ID". The database contains one record with the "oligo ID" entered as "T+". If I try to enter a new record with the oligo ID "T-", Filemaker tells me that I should use another ID because this one is already taken (not unique). It looks like Filemaker is comparing in the autovalidation feature only the ASCI characters and can not differentiate between - and +.

How to solve this problem without writing plus and minus?

Merci.

[LiveOak]

In Field Definitions --> Options --> Storage Options, change the indexing from "English" to "ASCII". With your current indexing, special characters such as "+" and "-" are ignored. -bd

[wollber]

quote:

---

Originally posted by LiveOak:

In Field Definitions --> Options --> Storage Options, change the indexing from "English" to "ASCII". With your current indexing, special characters such as "+" and "-" are ignored. -bd

---

Thanks a lot.

Bernd