Unable To Store A Calculation ??

[N Hagy]

For some reason I

[Robert Kidd]

I've had a very similar bug a while ago, is one of you fields that your concatenating together a lookup from another file ? If so try disabling the lookup and try reindexing your field

[N Hagy]

Yes I am concatenating lookup fields from another file and yes your suggestion worked. Thanks. I was using the concatenated fields to check for duplicates. I was hoping the the indexing would remain after I re-enabled the lookups but they reverted back to an unstored value. It's as if the lookups are being treated as related fields. Is there a fix for this???

Again, thanks for your help.

[Robert Kidd]

It's clearly a bug that somehow affects certain files under certain conditions.

I can't remember if this worked but try the following:-

If your fields are called FieldA and FieldB create fields C & D which are calc fields and simply equal Fields A and B respectively. Try indexing these new fields, if this works you should be able to concatanate C & D together to give the result you originally wanted

[N Hagy]

Robert

Tried your suggestion and got the same results. The calc fields responded same as the lookups. After setting them to store they revert back to unstore once I close the define fields window....thanks for trying.