I use this technique, for instance, in creating a "de-duping" screen where "Main" would be the "keeper" record and "Safe" would be a suspected duplicate record.
The user can pick two records and see the data side-by side; most importantly with any differences highlighted in yellow so they instantly see anything
that needs to be copied to the "keeper" before deleting the duplicate.
Here's an example formula for the conditional formatting, assuming you have a "MAIN" table, a "SAFE" table related to it (TO name is "main SAFE") and
all the applicable fields in "SAFE" are the same as in "MAIN" —
You can apply this SAME formula to each of the fields in the "MAIN" screen that you need to compare, since this formula uses the Self function.
me = Evaluate( GetFieldName( Self ) );
it = Evaluate( Substitute( GetFieldName( Self ); "MAIN"; "main SAFE" ) )
it <> me
Here's an attached Demo:
Thanks a lot for your explanation and the demo file! Very helpful, and a very cool way to compare field contents.