If Function Message

[Reid]

I'm sure this is simple but I can't figure it out. I want a script to do the following;

If (

field1+field2 (not equal sign) field 3 ; Message "The sum does not match field 3" ; do nothing

[efen]

Script?

Use basically what you have shown with a custom dialog for the message and set a script trigger - onobjectexit - with this script on field 3

[efen]

Sorry, I misread your query -- set the trigger on both field 1 and field 2

[Reid]

Script?

Use basically what you have shown with a custom dialog for the message and set a script trigger - onobjectexit - with this script on field 3

So I have a script trigger on object exit with this script in the IF function.

If (

MFInventory::goodparts+MFInventory::rejectparts ≠ MFInventory::Serial_Qty ; "The sum does not match the Serial Qty" ; ""

)

It doesn't work though because it doesn't come up with a message or do anything if the values are wrong. How do I create a pop up message? What's wrong with this formula?

[Reid]

I just figured out an easier way to do it. I just made the second value have a validation that says field1+field2=field3 with a custom message that says "The sums do not match".

Thanks for the help.