compare content of two fields in the same layout
Is there a way to compare the data in two different fields in a record? I want to verify that image ID numbers and object accession numbers match in my collection database.
There are probably more than a dozen methods:
a) a calculation field with an expression such as: If ( Field1 ≠ Field2 ; "message here" )
b) A conditional format can use table::Field1 ≠ table2::Field2 to change fill colors or even to make layout text visible or invisible
c) Hide object when (FileMaker 13 or newer) can control an error message's visibility
d) A Field Validation calculation one either field 1 or 2 or both can use a similar expression
e) The OnObjectValidate or OnRecordCommit trigger can run a script that checks the values
and other possibilities exist as well.
Retrieving data ...