Jump to content
Sign in to follow this  
VickyN

Calculations as match fields in relationships....

Recommended Posts

Please can someone straighten me out on this one.......

From what I was aware you were not able to use calcs as match fields in relationships....This is what I have been told.

Although I have by default done this and it worked. Please can someone explain to me why I was told this and the reasoning behind it!!! Life would be easier if this was possible! I hope whoever taught me this was wrong!

Share this post


Link to post
Share on other sites

If your calculation is STORED then you can use it as part of the relationship key.

If the calculation is UNSTORED then that is where there are limitations.

An unstored calculation can be used on the PARENT side of the relationship. It can NOT be used on the CHILD side of the relationship.

Hope this clears it up for you.

Share this post


Link to post
Share on other sites

Even STORED calculations must be INDEXED to make a key field. If indexing is switched off it will fail.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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