Checking to see if email already exists in Database
I'm posting this here as it's VTK specific although I'm working from a CSS Forn Builder Form.
So I adapted the registration form a bit (just deleted a few fields). Then added an Insert Record behaviour.
Then tested and it all works great.
I then decided to add one more validation to the email field. The idea is to compare the email submitted with emails already stored in the Users database and say "That Email already exists" if there is a match.
Firstly the form shows that error ALL the time regardless of anything.
Secondly the form does not submit even if the emails do NOT match. (It doesn't submit if they do match but that's the expected behaviour). If I delete the validation (Like Entry) then it goes back to working properly.
I have temporarily bound the recordset email address to the page and they are displaying correctly.
I've attached my page if anyone could have a look. It must be something I'm doing wrong but I can't spot it.
Many thanks.