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

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