john9210 Posted June 12, 2016 Posted June 12, 2016 I am examining a demo file. The field SportName uses a curious auto entry calculation. Let[Trigger=SportCategory;""], where SportCategory is another field in the same table. What's the purpose and what does it mean? Being auto entry, I thought it only effected new records.
comment Posted June 12, 2016 Posted June 12, 2016 9 minutes ago, john9210 said: Being auto entry, I thought it only effected new records. No, it can affect existing records, too. If the "Do not replace existing value" option is unchecked, the calculation will re-evaluate when any (local) referenced field is modified - very much like a stored calculation field. The purpose of defining SportCategory as a "trigger" is precisely that - cause a re-evaluation of SportName when the SportCategory field is modified.
Recommended Posts
This topic is 3338 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 accountSign in
Already have an account? Sign in here.
Sign In Now