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.
Connection
The connection to your database
Enable validation
When checked enable the recordset validation.
Recordset status
Define the validation you need: if the recordset is VOID or if is NOT VOID.
Target field
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.
Error message
The error validation is show
Table
The table where execute the recordset
Filters
The list of filter applyed to the recordset WHERE.
TYou can add/remove/modify this filters with the buttons in the right
