Calculations can evaluate differently in IWP.
In part because data on the page isnt written back to the database in the same timings as in FMP.
I dont remember where it is off hand but there is an article talking about the differences between how things evaluate in IWP.
Ill look for it but maybe Phil can drop by.
Thanks for your reply. I noticed something strange. When you have a field that is setup as a check box with a value list setup, when you check one of the boxes for a value in that field thorugh IWP, it writes the value to the field and does a <CR>. When you do the same through FMP, it just writes the value to the field, no <CR>.
I came up with an alternative that works in this scenario but I can definitely see being a problem in the future. I changed the value list from a check box to a pull down menu. My calculation field now updates properly. Any suggestions? I was thinking about opening a support ticket with FM because this seems very strange.
I also forgot to metion that I'm developing/testing using FMPA 11.3 and using IWP on FM Server Advanced 10.2.
Selected checkbox values are stored in the field separated by returns in both cases. You can watch this happen if you place two copies of a text field on your layout and format one copy as a checkbox group and one as an edit box. You'll see the values selected by the user in the checkbox group listed in the edit box copy separated by returns and listed in the order that they were clicked.
Id mention it. Is your valuelist table driven or is it a custom value list.