Global Storage & Indexing for CALC Fields
I am using calc fields for building relationships. For example, I have a calc field which calculates to "Active" in a table called "accounts" for building a relationship to filter only active accounts.
I have been keeping this field with "Global Storage", but I found issues where the relationship didn't work. The issue came up when I moved around several tables, and did some major changes to my DB. (it had been working fine until I made several changes, too many to list here).
When I changed the field to "Do not store calculation results" I found that it worked again.
So this brings me to the question: what is the difference? Is filemaker somehow "storing" this information somehwere? Does this have to do with "Flush cached joins"?
I guess I need to understand how storage works in this situation. If you have any comments or can point me in the right direction, I would appreciate it. I'm also using this type of method for filtering "Vendors" and "Customers" for the same "accounts" table.