Circular reference issue (1 Viewer)

[Hdata]

Thanks in Advance!
I'm trying to create a formula at the table level which creates a circular reference problem that way I am doing it.
I am using two fields; acres and square feet. One acre = 43,560 sq. ft.
I would like to input the number of acres and get the number of sq. ft. calculated automatically. Also, when I input the number of sq. ft. I want the number of acres calculated automatically. Any suggestions?

 

[MarkK]

Use three fields. One should be the authority, and maybe it should be hidden. The two fields you update are subservient fields, child fields. This will be easier in a form. A table doesn't allow you very much control.

 

[Hdata]

Thanks, works great!