Unstored calc to indexed field

[Jim McKee]

I have a calculation in File1 based on the comparison of two related values in File2. So, the calc, which returns "1" or "", can't be indexed. I want to get the result into an indexable field in File1 whenever the calc changes.

I think I remember a discussion here about a way to automate this using modTime, a calc built on a Case() statement and a Lookup. But, for the life of me, I can't remember the setup, and I can't find the thread here.

Can someone point me to the thread or, if not, describe how to set this up? Or, maybe I'm dreaming?

TIA

[Vaughan]

Look on Ray Coglon's web site, there may be something there.

http://www.nightwing.com.au/filemaker

[Ugo DI LUCA]

I think ir's here too in the article section.

Basic settings, which may differ from Ray, and hacked from Bob's is

serial

Mod Time (autoenter)

c_Trigger = (ModTime*0) + serial

RelTrigger --> c_Trigger::serial

Then, your field would lookup the unstored calculation based on the RelTrigger.

BUT this will only happen on a record by record basis, so you have to be on this record to have it happen...

[Jim McKee]

Ugo ...

I found it in the Articles area. Ray's post is called (imagine!): [color:"blue"]"Automatically indexing non-indexable fields".

Doh! How dense can I be?

Thanks to you and Vaughn.