show region if user exists

i have created a form using form builder and security assist,which i have attached.

the form works fine however, I would like it so that when a cutomer trys to sign in again, a show region appears which which says that that email address is allready being used. give them a link to go to login page or page for them to get there password info ontop of the form.

you need to create a lookup recordset to see if the email address exists in the users table.

Set the Recordset to filter the email column on the email form element.

the recordset will create a variable named $numRows_<recordsetName> (where <recordsetName> is the name of the recordset) this can be used to determine if the recordset is empty, if it is empty, the email has not been registered.

to do this, go to Window -> Server behaviors and double click the Server Validation server behavior.

for validation type, select numeric. for the server variable enter:
$numRows_<recordsetName>

set the minimum number to -1 and the maximum number to 0

this will cause the validation to pass only of the lookup recordset is emtpy.

you can use the validation sow if server behavior to show your email in use error message and link to the login page.