Calculation Field will not calculate
I am using FMP12 Advanced on OS 10.6.8. I just recently placed a calculated field in a table to make a salutation for a form letter. The calculation is "Dear Bro." & " " & Trim ( LNAME ) & ":" I do not have the "Do not replace..." paramenter checked. I do not have the parameter "Do not evaluate if all referenced fields are empty..." checked. But when I correct current data in a record, it is not performing the calculation. Nothing shows in the calculated field.
Is this a field that existed before you added this auto-entered calculation? See if creating a new record results in this field working in the new record.
Existing records do not update automatically when you add or change an auto-enter calculation expression. Here's a way to get them to update: Updating values in auto-enter calc fields without using Replace Field Contents