Calc. field for relation field doesn't work, why?

[snekkis]

I have a calc. field which I'm basing a selfjoin portal with relationship fields to be listed. So, any time that calc. field is altered the list of related records should be altered too. But I get "This relationship will not work because the field "..." cannot be indexed."

I can think about a script to set the relationship field, but how tedious? It would be nice if it coul be based upon a calc. field somehow.

[danjacoby]

One (or more) of the fields involved in the relationship you are trying to create cannot be indexed. Find the field(s) involved, and change the relationship (or the fields).

Without more details (like what all the fields are and exactly what the relationship is), that's the best that we can do. Personally, I recommend that rather than sending the file and having someone else figure it out, you go through the affected fields and figure it out yourself -- that way, you'll know how to solve this problem in the future.

"When someone tells you something, you have been told; when you discover it yourself, you know it."

[snekkis]

It is only that specific field, no other field that can be used. Does this mean that you can not use calculation fields in a relationship, and that you must use text or number field???

In that case, what I mean is that I have to set the text field through a script based upon that specific calc. field.

I don't know if I''m terrible to explain. I don't know how different I can explain it either.

[enzo01]

In a relationship, only the right side of the relationship must be indexed, so you might like to check the define field options for that field you're using.

May be you simply forgot to check the box for the indexing process, may be this field cannot be indexed if it references a global or a relationship.

No, you can use a calculation, but it must be indexed.

[snekkis]

I see now from when I try to make it indexed that it falls under the message criteria for "...cannot be stored or indexed because it references ... an unstored Calculation in its formula."

I can't make any changes to that specific calc field. I get the same message here. This is the formula in that calc field:

If(Betalingsfrist - Status(CurrentDate) < ZeroField and IsEmpty(TickContainerBetaltFaktura),GetRepetition(Forfalt tekst, 2),GetRepetition(Forfalt tekst, 1))

This formula contains containers and Global containers.

Is this why the calc. can not be stored?

[enzo01]

Yes.

You should try to either find another field from which you would base the relationship upon and/or index this unidexable calculation.