Jump to content

Indexing a calculation field?


This topic is 8502 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Is it possible to index a calculation field that uses another field from another database?

e.g.

In the main database I have a field call "A" which has this calculation:

Max(Academic History::Term)

Any help would be greatly appreciated.

Link to comment
Share on other sites

No, because Filemaker doesn't update it's index whenever related records and unstored calculations change. So, the index would be wrong after a change to the record in the related file. It would be a major undertaking and would probably slow Filemaker down way too much for it to track all these things.

The best you can do is create another field that is set to the value of your calculated field by using a Replace command or a Looping script. That field can be indexed, and you can use it in finds and sorts. You just have to update it regularly.

Link to comment
Share on other sites

This topic is 8502 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.