Hi - I'm having problems with manually validating a stock code field on an 'order items' date entry form. The form is a portal on a 'sales order' form. I'm on FMPro 16 using a FMS 16 database.
The user can key in a valid stock code, or a special code for a message line, or leave the code blank to move to the description field and key in using auto-complete. Because of these latter options and some auto-populating of prices and qty I have to validate the field using a script which I'm triggering with onObjectValidate. The script checks the validity of a relationship between the order items table with the main stock table based on the stock code, and if it doesn't find a valid relationship, shows a message and keeps the user in the field with an exit script: false.
This works fine if the code is valid, and correctly handles an invalid code, but when you correct an invalid code to a valid code it doesn't give a valid outcome. I can't work out why. My workaround is to use executeSQL to check the active field contents against the main stock table, but this feels clumsy to me.
What am I doing wrong and how should I do it instead?
Thanks in advance.