comparing field values

[micke11y]

Is there a way to make filemaker match the exact string instead of just the first matching substring when comparing fields in defining relationships? ex: 15-A' should match to 15-A' only and not 15-A

Thanks a lot!

[oilman]

use the field exact match sybmol ==

[Kurt Knippel]

I believe that what is happening is that your fields are set to be indexed by English. In this case the ' is not part of the text and so does not get indexed. Set your indexing to ASCII and it will index all the characters.

[micke11y]

Dear Kurt,

I just wanted to say thank you so much for your reply! It worked like a charm =) and everyone at the office is grateful. THANKS!

Alice

(micke11y)