Anyone have any thoughts on how to force one field's auto-enter calculation to calculate before another field's auto-enter calculation?

Perhaps a better question would be...Does anyone know what controls the order in which auto-enter calculations calculate in a table?

I have a field(Field1) that has an auto-enter calculation that references another field(Field2) in the same table. Field2 also has an auto-enter calculation, but I want Field1's auto-enter calculation to calculate using the data that is in Field2 before Field2's auto-enter calculation calculates.

Make sense? Any ideas are welcome.

... but I want Field1's auto-enter calculation to calculate using the data that is in Field2 before Field2's auto-enter calculation calculates.

It seems that Field2 will calculate when a Field3 will change.

So, something like this into Field3, will solve your problem:

Let(

$$Field2 = Field2;

Field3

)

and, for Field1 :

Evaluate( $$Field2 ; Field3)

Thank you very much Daniele! Your suggestion didn't completely solve the problem, but it did get my mind going in a new direction and I was able to solve my problem.

I REALLY appreciate your help!!!!