Overwriting a Calculation Field
I have two fields on my form: "Project Area in Acres" and "Project Area in Square Feet." Right now, I have it set up so that Project Area in Square Feet is a calculation field ( = Project Area in Acres * 43560). I'd like to set it up so that users can just enter Square Feet directly, in case they already have that information. But I can't find a way to modify the calulation field to allow that.
I also toyed with making Area in Square Feet a number field that is validated by a calulation, but that doesn't seem to work.
I'm using FM 10. Any ideas?