Double click Field3 in Manage | Database | Fields
Click the validation tab.
Select the calculation option.
Enter this expression:
Self = ( Field 1 + Field 2 )
Enter the message you want to appear if the validation rule fails in the custom validation message box at the bottom of this dialog.
If this is not what you had in mind, please describe what you need in more detail.
Great Thank you. I Was trying to do it with the IF Fuction. I need to learn about what SELF does
Now if the number is validated by entering the corect number.
the next step in the script would be to creat a new Record?
What fuction would i use to use .
Thank you for your help
Like any unfamiliar term you might see in a forum post, Self is something you can look up in FileMaker Help in order to learn more.
I'm not sure that a validation rule is what you really want here.
Can you describe in more detail the full process you need here?
Best guess is that you need to use a script trigger to perform a script such as the OnObjectSave trigger. Such a script could compare Field 3 to the sum of field 1 and Field 2 and then create a new record as appropriate.