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.

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.