indexing a related field

[Aussie John]

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

[The Shadow]

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.

[Vaughan]

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

[Aussie John]

thanks guys I'll look at those options