Save Validation Fields to a Different Table

Overview

Use validations to make sure forms have the correct data entered.

Details

You may not be aware that for a validation to fire correctly, you must have a field name and table name in the Object Inspector. The validation needs to save this data somewhere, so without the FieldTable and FieldName, it will not fire at all. 

The table below shows that the control saves to the primary FD__table.

However, if you do not want the validation to be saved in the FD__Table you can save it to a second table. This sample table is named FD__Garbage_Temp.       

Check the Design view of the form under Object Inspector > Validation. Notice that this example is only validating on True or False. The control being validated, :HiddenCount, is saving to the FD__Garbage_Temp table instead of the FD__SAVE_WITH_SIGNATURES table. Notice that the OP__Docid on both tables is the same since they refer to the same record. 

Make sure you add the table name of your alternate table to the Properties of the form.