I'm trying to create fields that auto-enter using a calculation, so I can allow user to override the calculated results (in this case to change a shipping cost ) When I enter a calculation that worked fine when used in a calculated field, nothing happens - nothing is entered in the field. I can't seem to find anything in my reference books or the FMP manual.

What am I doing wrong?

Thanks.

Alan Rock-Blake

Hello Alan,

Auto-enter calculations do not acquire a result at the time they are defined - they must be triggered by an action within the database such as creation of a record or entry/editing of data in a field which they reference.

If you have a number of records already in existence which you wish to update to match the auto-entry calc, I suggest you use the Replace Contents... command (using the by calculation' option and specifying the same formula you are using for the auto-entry calc) to apply the calculation to those records.