Check if already exists on insert
I am using Data Assist to do a single record insert. I of the form fields captures an email address which needs to be unique in the database. I therefore need to do a check before the insert to ensure that the email address entered does not already exist as a record.
Are there any Web Assist tools available which I can combine with Data Assist to help me do this or what other alternatives might be avaibel to me?