Since I used FM and this is for sure, I noticed that autocalculation does not work as calculation alone when the calculation syntax is complex. This is generate problems if someone want to have a field not only to show results of the calculation but to give the abbility for the client to complete the field with own values.

Sometimes you have to click outside the field, sometimes the result dissapear so the field become useless. If someone have to suggest anything I appreciate to put it here so other FM users can see it.

Pascal

Would you be so kind as to post a sample file specifically showing the problem you describe?

I tried to make a new file with the autocalculation mentioned in my post. For my surprise I see that it works to a new file. Is it necessary autocalculation refers to fields of the same table or related fields can do the same job?

My database is also full of Portals one inside the one many times. Is this plays any role here?

Pascal

Is it necessary autocalculation refers to fields of the same table or related fields can do the same job

No - but it needs to be stored fields though ...this is a FAQ - so read on McDuff:

http://www.fmforums.com/forum/showpost.php?post/252502/

Similar can't you expect data in related tables unstored field change to the beat of a global field "drum" a relation away ...the way to circumvent it is to move the global to the same table and just show it a relation away.

But please read Comment's wise words thoroughly!!!

--sd