As a follow up to SWS' post, although there are situations where retaining the calc itself might be useful, (ie you can go back to it later on), showing the dialog "The field is in use" is wrong and misleading. The dialog should take into consideration that the step has been altered to not use that field any more. If a novice user goes back to that script and finds
"Go To Layout [original layout]"
as the only step in the script, trying to figure out where the field is being used is impossible. It's no longer accurate to report on unused fields in that way.
So these processes should be changed to clear out calculations that aren't being used, or any process that checks the usage of fields should allow for it and report accurately.
Personally I can't see a value in retaining the calculation after the script is saved - while you're editing it possibly, but not once it's committed.
SWS and Nicholas Orr:
Thank you for your comments.
I have verified the problem exists with FileMaker Pro 10 and FileMaker Pro 11. I have forwarded your posts along with my findings to our Development and Software Quality Assurance (Testing) departments for review and confirmation. Until this is changed, clearing the calculation formula before changing to a static option is definitely one option.