Indexing trouble (without calculated or related..)

[michele]

Strange,

I've been trying to store a calculation(to create a relationship) that looks like:

field 1 &"_"& field 2 &"_"& field 3

All fields are number fields and indexed.

A similar calculation: field 1 &"_"& field 2 stores without any trouble.

Filemaker allows me to check the "indexing on" button. Even mentions that it's indexed but when I open the define fields dialog box after closing it, the indexing is gone.

Field 3 is a number field with a calculated result that's being inserted.

Does anybody know what's happening here? I'm working with fm5.

Thanks for reading and eventually answering my question.

Mich

[LiveOak]

Try setting the indexing language to "ASCII", otherwise the "_" characters will be ignored and 1_11_11 will look just like 11_1_11 and 111_1_1 (all 11111).

-bd