Indexing a Field that is a Calculation

[Joseph31]

Ok,

So I have a fields named "Surv". This field is a calc field... a simple case function. When I go to storage options I can not change it to any indexing. So here is my problem.... How do I make a portal Index itself off of a calculation field... Noting shows up in the portal... Is there a way to make this work?

Oh, I know about the auto-enter calculation... that works but I need the number to chang when I change fields... auto enter only works when I enter a new record...

Help,

Joseph

[-Queue-]

Auto-enter works each time a record is modified, if you have 'do not replace existing value for field' deselected.

If a calculation involves globals or unstored calculations, it cannot be indexed.

[Joseph31]

I have some calculation that indexed... in my database... why can some and not others...

Also, I did the auto calc field... and unchecked field box... but i already have 600 entries in my database... when do I have to do to cycle through them so it does my case function?

This is why I like calculations b/c they change automaticaly everytime...

Joseph

[-Queue-]

You have to modify each record in some way for the auto-enter to re-trigger.

Re: your first question, re-read above post.

[Joseph31]

Soory, Did not see that before... I understand....

Thank you,

Joseph

[Joseph31]

Ok Please tell me why?

I can Index this equation:

Case ( IsEmpty ( Survior_Second_FirstName); ""; TextColor("Surv";RGB(255;0;0)))

But Not this one:

Case ( IsEmpty ( File_Login_Sheet::Survior_Second_FirstName); ""; TextColor("Surv";RGB(255;0;0)))

Joseph

[-Queue-]

The second one involves a related field. Only calcs involving local, non-global fields can be indexed.

[Joseph31]

Thank you,

I guess I will have to rethink this... I need to min user input somehow... I thought this would be a good way to do it. I was wrong I guess. I thank you for your time.

Joseph