Hi I have a calculation that used a related field. I want to Index this field but FM wont let me. Any work around you can think of? thanks

If you use the new Lookup function in your calculation, ie:

"Data: " & Lookup(relatedField)

then the calculation can be stored. Of course, it won't recompute itself when the related data changes, but that's an option that now exists.

John

About the only way is to create a look-up field in the file (which can be indexed) then base the calculation on that looked-up field.

The challenge is that the two values are now no longer connected. A process needs to be implemented that performs a reloopup if the related record's data changes.

I believe Ray has a solution on his website:

http://www.nightwing.com.au/FileMaker/resources.html

thanks guys I'll look at those options