With this validation you can validate your fields with a recordset, you can check is a record exists or not depending on your form fields value
For example can be used to verify if a mail or a user-name exist or not.
Usefull for registration form.
We add 2 recordset validation so you can check for 2 different form fields.
The connection to your database
When checked enable the recordset validation.
Define the validation you need: if the recordset is VOID or if is NOT VOID.
The form field this validation is attached. The recordset validation start only if the standard validation on this field are valid. So if you setup this field as required the recordset validation start only if it is filled.
The error validation is show
The table where execute the recordset
The list of filter applyed to the recordset WHERE.
TYou can add/remove/modify this filters with the buttons in the right