CONNECTING MULTIPLE TABLES.
it will come from the LAST RECORD YOU CLICKED IN OR OPENED; NOT necessarily the PREVIOUS record in the table you are using.
Text, Date, Time, and Timestamp values
It allows you to program it to do a calculation, BUT YOU CAN ALSO CHANGE THE FIELD if you want to.
CALCULATION FIELDS, on the other hand, always create their OWN, UNCHANGEABLE VALUES.
It allows FM to automatically fetch a value from some record in ANOTHER table and plop it in this field.
THIS IS CALLED A LOOKUP.
changing a value that should stay the way it was entered forever, such as when using the CREATION and MODIFICATION options