Help with Unique Database Value validation
I need to check if an e-mail address already exists in the users table in database.
I've selected 'Unique Database Value' as the server validation, chosen the connection, selected the users table and selected the e-mail field as the 'Unique column' in that table.
Can you clarify what the 'key column' and 'key value' options are for? I understand that they are for update pages, so I'm guessing that the key column should be the ID field for the row. What should the key value be set to?
Also, what should these settings be for an insert table?