AnsweredAssumed Answered

Insert Calculated Result Script step points at wrong field.

Question asked by RichardTuner on Dec 8, 2011
Latest reply on Dec 8, 2011 by philmodjunk

Summary

Insert Calculated Result Script step points at wrong field.

Product

FileMaker Pro

Version

10.0

Operating system version

OSX 10.6.8

Description of the issue

I have run into this since I started using FM11. This is the specific expample, but I have the same issue with the Button definition as well from time to time.

Insert Calculated Result [Select; RS_Inventory::INV_Item_On_Hand ; RS_Inventory::INV_Item_On_Hand + RS_Inventory::INV_Temp_holder]


The script step has worked fine for years. Suddenly it will start placing the Calc result in the Item Name instead on On Hand.
If I delete the field from the Layout, it will place the result in the UPC field.

And it replaces all instances with whatever field it is using at the time (adds Temp Holder to itself)

It actually messes up all opened versions as well (shared over network).

Steps to reproduce the problem

Have not been able to reproduce the glitch, it just will show up from time to time.

Workaround

The only fix that gets results is to delete all fields on the Layout and replace all of them. Replacing the Script step will not fix the issue.

This works until it glitches again weeks or years later.

Outcomes