RECORD Level Execution

This is the Execution designation of the index. Record-level execution means that FileMan will execute the cross-reference logic only once after all the fields in a record are edited, typically at the end of an editing session. This is in contrast to Field-level execution, where FileMan executes the cross-reference logic after each and every field in the cross-reference is edited.

For example, if both the DOB and SSN fields are contained in a single input template, but the index is defined as having Field-level execution, the cross-reference logic would be fired twice: once when the DOB field is edited, and then again when SSN is edited. Record-level execution means that even if the user edits both the DOB and SSN fields for a record, FileMan will execute the cross-reference logic only once at the end of the editing session.

In most cases, simple indexes should have Field-level execution, while compound indexes should have Record-level execution.